Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need help with DAX please!!

Hi.   I am trying to do something that seems fairly simple but failing miserably. My background data is in a SharePoint list.   I am trying to accomplish the following:   Total number of...
  • goncalogeraldes's avatar
    goncalogeraldes
    5 years ago

    Hello there Anonymous ! If I understood your question correctly I think you dont need the 'Measures of Success'[Area] = "A - Con" condition in your calculate formula since PBI will do it when you add the measure to the table/matrix visual. Try adding this measure to your table/matrix visual:

    Impt1S =
    CALCULATE (
    COUNTROWS ( 'Measures of Success' ),
    'Measures of Success'[Importance Text] = "1",
    'Measures of Success'[Results] = "Success"
    )

     Hope this answer solves your problem! If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
    Thanks!

    You can also check out my LinkedIn!

    Best regards,
    Gonçalo Geraldes