Forum Discussion
Solved
Measure Help - VAR Formula
I need to do a measure and I'm a lil stuck on the best way to go about it. Each person logs what they do in a day, and each person can have several entries per day. I need a VAR to assign 1 for ...
Hi, smather ;
In your data, here is "a." and "c." ;not "a", "c".
so you should change the measure.
MyMeasure = CALCULATE(DISTINCTCOUNT('Table'[Full Name]), 'Table'[Cat] in {"a.", "c."})The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, smather ;
In your data, here is "a." and "c." ;not "a", "c".
so you should change the measure.
MyMeasure =
CALCULATE(DISTINCTCOUNT('Table'[Full Name]), 'Table'[Cat] in {"a.", "c."})The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.