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.
Hi All,
Normally when doing measures, and you e.g. add a table with categories and the measure, within a date range, you would normally only get values for the categories that actually have values for the period. So e.g. the last month we have data from batch 20-25.
But for some measures, I will get all the previous batches included, even those closed out and with no generated data. So batch 1-25 will be included, and all the old and inactive/finished batches will have a value of zero.
Can anyone explain why measures sometimes lead to this behaviour? It is a bit of a hassle trying to filtering out the old values without affecting real values.
Best regards,
Ole
Solved! Go to Solution.
It depends on whether the measure returns blank or 0. If the measure returns blank then by default those values will be filtered out, but if it returns 0 then the values will be shown.
It depends on whether the measure returns blank or 0. If the measure returns blank then by default those values will be filtered out, but if it returns 0 then the values will be shown.
Aha, turns out the measure I was working on excluded some groups (those 0 or blank), so I added an IF(AND() for zero and blank, and now it works normally. Thanks!
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |