how to write following mesure

TKray23 — Mon, 11 Sep 2023 18:50:14 GMT

how to write the following measure:

I need to count distinct Record IDs if Value in Column A >0

Table ABC has Columns: Record IDs, Column A, Column B, Column C- ,...

Record Ids are Listed several times in the table, depending on Values of Columns B, C,...

Column A is "filter" (1,0) and is used to count instances depending on Column B's value.

Now I need to get a sum of the unique Record IDs if Value in Column A >0

Re: how to write following mesure

Idrissshatila — Mon, 11 Sep 2023 19:25:06 GMT

Hello TKray23 ,

Try the following
DistinctCount_ID_GreaterThanZero =
CALCULATE(
DISTINCTCOUNT('YourTableName'[ID]),
'YourTableName'[Column A] > 0
)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡