Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I calculated the distinct count of doors with no orders.
If I use the table visual, I am getting the correct result but if I use the Card visual I am getting a different result.
So I created another formula which is the SUMX but still got the same result as the other measure.
Sample:
Formula 1:
CALCULATE(DISTINCTCOUNT('StoreMasterfile'[StoreCode]),
FILTER(DATATABLE, DATATABLE[TYPE] = "SALES" &&
SOLD <= 0
))
Formula 2:
SUMX(StoreMasterfile, [Formula 1])
I also tried this:
SUMX(VALUES(StoreMasterfile[StoreCode]), [Formula 1]
But still got the same result.
Please help. Thank yoU!
Hi @fssebastian ,
Because of the row context, your measure will be affected in the table visual.
Try the formula which is added with the ALL function:
CALCULATE(DISTINCTCOUNT('StoreMasterfile'[StoreCode]),
FILTER(ALL(DATATABLE), DATATABLE[TYPE] = "SALES" &&
SOLD <= 0
))
If still in doubt, please provide some sample data, and expected results.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |