Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a Measured column that shows the variance between 2 columns..
Solved! Go to Solution.
Hi @StuartSmith ,
You can do a caluclation as follows:
NegaticveCnt = CALCULATE(DISTINCTCOUNT(tablename[Country]), tablename[GroupCol] = "Negative")
Do similar measures for Positive and 0.
Thanks,
Pragati
@StuartSmith ,
I replicated some sample at my end as per your deets.
SO create first one calculated column:
Hi @StuartSmith ,
You can try created a calculated column as follows to use on pie-chart:
GroupCalc = IF([Measure] = 0, "0 Values", IF([Measure] > 0, "Positive Values", "Negative Values"))
Replace [Measure] in above DAX with your measure/column.
Thanks,
Pragati
Thanks, your measure worked great, but then reaslied the result wasnt exactly what I wanted. I now have a table similar to the below
The chart is then conting each row, so Negative = 2, Positive = 2 & 0 = 1, but I realised that I need it to count each distinct country, so Negative = 1 (UK) , Positive = 1 (France) & 0 = 2 (Germany & Spain).
I am trying "DistinctCount" with your measure, but can figure it out. Hope that makes sense.
Hi @StuartSmith ,
You can do a caluclation as follows:
NegaticveCnt = CALCULATE(DISTINCTCOUNT(tablename[Country]), tablename[GroupCol] = "Negative")
Do similar measures for Positive and 0.
Thanks,
Pragati
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |