Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am looking for a way to display only the months selected via a slicer in the title header as per the below screenshots:
The formula I have at the moment was done via quick measure but for some reason at the moment the card is displaying April, August, December - when the month filter is set to all months currenrtly? It works if I then select a month or multiple but I dont want to see the three months that are listed currently.
Many thanks
Jay
Solved! Go to Solution.
@JayTG123 You can add a VAR to get ALL of the months like
VAR __AllMonthsCount = COUNTROWS(DISTINCT(ALL('* Month Table'[Month)))
Then you can add an IF statement where if your two counts are equal to one another, just return BLANK because no months have been selected.
@JayTG123 You can add a VAR to get ALL of the months like
VAR __AllMonthsCount = COUNTROWS(DISTINCT(ALL('* Month Table'[Month)))
Then you can add an IF statement where if your two counts are equal to one another, just return BLANK because no months have been selected.
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
66 |
User | Count |
---|---|
115 | |
103 | |
93 | |
64 | |
61 |