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.
Dear all, good morning.
I've been having a hard time calculating our sales Hit ratio. The reason is , after I apply a slicer and filter by status, the total won goes wrong.
Here is the data
total_quotes = calculate(distinctcount(table'QTY')
total_won - calculate(distinctcount(table'QTY'),Status="Won")
Until here it works well, but if I create a filter with the status and select loss the below happens
So I am selecting all QTY that are lost, but it still gives me the total of won as 2...
Why is this happening?
Solved! Go to Solution.
In your measure:
calculate(distinctcount(table'QTY'),Status="Won")
CALCULATE overwrites the existing filter on Status. So although you filter to Lost the DAX replaces it with Won.
Try
calculate(distinctcount(table'QTY'),KEEPFILTERS( Status="Won" ))
In your measure:
calculate(distinctcount(table'QTY'),Status="Won")
CALCULATE overwrites the existing filter on Status. So although you filter to Lost the DAX replaces it with Won.
Try
calculate(distinctcount(table'QTY'),KEEPFILTERS( Status="Won" ))
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |