Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
I have a measure of the minimum sales value:
MIN Sales =
VAR t = MINX(CALCULATETABLE(SUMMARIZE('Calendar';'Calendar'[YearMonth];"value";[Sales]);ALLSELECTED('Calendar'));[value])
RETURN IF(ISBLANK([Sales]);BLANK();t)
Tell me please, how to make a filter that will remove the month of comparison?
Solved! Go to Solution.
Hi @Dima_R,
In the Visual level filters, please set your measure is not blank(highlighted in yellow background) as follows, and click Apply filter.
Best Regards,
Angelia
Hi @Dima_R,
Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.
Best Regards,
Angelia
Hi @Dima_R,
In the Visual level filters, please set your measure is not blank(highlighted in yellow background) as follows, and click Apply filter.
Best Regards,
Angelia
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |