locked
How to replicate a measure used in SAP BO to DAX RRS feed

  • Question

  • Hi 

    Sorry if this a wrong forum.

    I am trying to replicate one of the measures created in SAP BO to tabular model using DAX. Below is the existing measure formula

    =Count([A]) In ('Table'.[B];'Table'.[C];'Table'[Calculated Column1]) Where ([Flag] = "30 Days")

    How should I replicate the same using DAX 

    Please advise



    Monday, November 16, 2020 5:24 PM

All replies

  • Hello DAXLearner11,

    The purpose of this forum is to support the Open Specifications documentation. You can read about the Microsoft Open Specifications program at https://msdn.microsoft.com/en-us/openspecifications/default. The library of Open Specification documents is located at https://msdn.microsoft.com/library/dd208104.aspx.

     

    It doesn’t appear that you are implementing one of the protocols cited. if you are working with a specific on-the-wire Windows protocol please provide additional information regarding which protocol so that we can better understand how we can assist you.

    We suggest posting to one of the SQL forums here:

     https://docs.microsoft.com/en-us/answers/products/sql-server

    Best regards,



    Jeff McCashland | Microsoft Protocols Open Specifications Team

    Monday, November 16, 2020 6:35 PM
  • Hi Jeff,

    This question is related to SQL Analysis Services (SSAS). When I am trying to post this question to SSAS forum it is showing SSAS option in "Ask a question" page. Can you please help me with this issue or let me know the process to post a question in SSAS forum. Please let me know the process.

    Thanks

    Monday, November 16, 2020 7:09 PM
  • Hi DAXLearner11,

    The SSAS link at the page indicated above is the correct forum, and "Ask a question" is the right method to post your question to the forum. When you click the 'Ask a question' link, you will be presented with a form to fill out with your title and question. 

    Best regards, 


    Jeff McCashland | Microsoft Protocols Open Specifications Team

    Monday, November 16, 2020 8:34 PM
  • Hi Jeff,

    I clicked the link "Ask a question" and it took me to blank question page.  But I was not able to see SSAS in the list of forums mentioned there. Even not able to find SQL Server as well in the available forums list.

    Please advice.. 

    Monday, November 16, 2020 9:53 PM
  • Please try these steps:

    1. Navigate to: https://docs.microsoft.com/en-us/answers/products/sql-server

    2. Click SASS

    3. Click 'Ask a question'

    4. Fill out the form with a title and your question. When you enter the title, it will suggest threads and forums where your question may have already been asked and answered. Just ignore this. They are only suggestions. 

    5. Add the tag "sql-server-analysis-services"

    6. Submit the question. 


    Jeff McCashland | Microsoft Protocols Open Specifications Team

    Monday, November 16, 2020 10:46 PM
  • Matt,

    Thanks for the process and helping to find the correct place to post question.

    Thanks

    Tuesday, November 17, 2020 2:45 PM