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 Community, I would like my measure in table to ignore when slicer is selected.
Below is my measure which is calculating previous month income based on week ranks and is showing blank when slicer is selected
Thank you in advance for any suggestions/advices.
RV
Solved! Go to Solution.
Hi @RJ_KON,
In your formula, you need to apply the filter for CW variable as well:
VAR CW = CALCULATE(MIN('Calendar'[WeekRank]),REMOVEFILTERS('Calendar'[Financial Week]))
Hi @RJ_KON,
In your formula, you need to apply the filter for CW variable as well:
VAR CW = CALCULATE(MIN('Calendar'[WeekRank]),REMOVEFILTERS('Calendar'[Financial Week]))
Hi Govindarajan, it worked.
Thank you
RV
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 |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |