Forum Discussion
exists in same table
Anonymous ,
Create two measures using DAX below:
count with true = CALCULATE(DISTINCTCOUNT('Table'[A]), FILTER(ALLEXCEPT('Table', 'Table'[B]), 'Table'[C] = TRUE()))count with false = CALCULATE(DISTINCTCOUNT('Table'[A]), FILTER(ALLEXCEPT('Table', 'Table'[B]), 'Table'[C] = FALSE()))Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you PattemManohar !
lets say i have the following data: (ignore column D, it's only to show that data is distinct)
(of course real data is much bigger)
I need a report (or a graph) that will count distinct countries for each president that have at least one true value in column C. and a count of countries without any true value.
so the report would be like that:
I guess there are a few ways to do that, but i'm not sure how...
Thanks a lot
I know my original question didn't mention all that :smileyhappy: I was just trying to simplify
Community SupportAnonymous ,
Create two measures using DAX below:
count with true = CALCULATE(DISTINCTCOUNT('Table'[A]), FILTER(ALLEXCEPT('Table', 'Table'[B]), 'Table'[C] = TRUE()))
count with false = CALCULATE(DISTINCTCOUNT('Table'[A]), FILTER(ALLEXCEPT('Table', 'Table'[B]), 'Table'[C] = FALSE()))
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PattemManohar and v-yuta-msft great thanks!!
(i think i'm missing the accept bottun... where is it?)
found it :robotlol: