Forum Discussion
Solved
Condition in Distinct Count ( Measure)
Hi Everyone, I need to get distinct count of organization based on certain conditions. I am getting below error in the measure. Please help me to correct this. Measure 5 = var test1=CALCUL...
Kavya123 ,
You may add FILTER Function to the formula.
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
Kavya123 ,
You may add FILTER Function to the formula.
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
Thanks for the reply.. I was able to resolve.
CALCULATE( COUNTROWS (FILTER (VALUES( PROFILERTABLENEWSUBMITTED[POrganization]),if ( and ([Measure 2]>[Measure 4], [Measure 3]<[Measure 4]), 1,0) )) , FILTER( PROFILERTABLENEWSUBMITTED, PROFILERTABLENEWSUBMITTED[PDataPoint]=1208 || PROFILERTABLENEWSUBMITTED[PDataPoint]=1207))
