Forum Discussion
Distinct Count with true/false
Hi, I have a table with custumer and a percent value. I want to calculate the number of custumer who is under 50%. My goal is to create a card graph, with this total. I tried many measure (coun...
Hi chestercas ,
Card Visual is equivalent to the Total row in the table, when the Total row is blank, Card Visual will also show blank, you can try the Sumx() function
You can create a Measure
Flag =
SUMX('DATA_BRMC',[VAR bour])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you ! It doesn't work too...
I created 2 measures :
| Bour test = CALCULATE(DISTINCTCOUNT(DATA_BRMC[Nom prénom CC]),FILTER(DATA_BRMC,_txFAC<0.5) |
| Nb dépo FAC = SUMX(DATA_BRMC,[bour test]) |
As you say, card takes blank rows...
So I show my 2 measures on a table. [BOUR] detect correctly txfac>0.5. But [nb dépo FAC] no... And also, it count all rows >0.5 in my table. I just want a "1" value on my select period... 😞
Thanks for your help and your time ! 🙂