Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have a measure forecasting the total gifts for the present FY which seems working fine in a card visual:
However, when I referenced it in another measure using SWITCH, the value was not showing up:
Can someone explain to me why this is happening and what changes I should make for the value to show up correctly?
Thank you very much in advance!
@acao-96 SELECTEDVALUE only returns a value if there is only one value in the filter context otherwise it will return a blank, you need to investigate if the filter context contains more than one value, just use DISTINCTCOUNT to make that check.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |