Forum Discussion
PBI Distinct Count with multiple rows and column
Hi All, How to create measure to count DISTINCT IDs from multiple criteria from specific row and column? Below are sample dataset and the condition to create measures. Criteria: How m...
Anonymous
You can use the following DAX measure-
Measure1 =
CALCULATE (
DISTINCTCOUNT ( Table[id] ),
FILTER (
Table,
Table[prevstepid] = "Proc1"
&& Table[stepid] = "Verify"
&& Table[prevstepid] = "Verify"
&& Table[stepid] = "Fail"
)
)
Like this, you can create the other 2 measures.
Please let me know if this didn't help.
Not working using the actual data. I tried one filter (Proc1 and Verify) and its working but if 'm using multiple && condition, no values appear on my matrix and card visualization.
Anonymous
Can you share the sample data or just copy-paste the data in excel format here?