Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I want to add a single Card which filters differently to rest of report, i.e. only show ave of score of latest months' data.
I created new measure which works, i.e.: M1 = Calculate(Max(CSI[Month]))
Then to filter for latest month CSI score: M1CSI = Calculate(Average(CSI[CSI], Filter(CSI, CSI[Month] = CSI[M1]))
This however still calculates base on full set of filters on the page?
Thank you
Do you want the single card visualisation to show ONLY the CS! Score for the latest month, and all other visualisations to show the CSI for all months?
Are you doing this entirely through your measure or do you have other filters applied at either a Visual or Page level?
Yes, the single card only should show latest month.
Rest of Page level has different filters applied to that. However, my single card filters according to rest of the page filters, meaning the filters applied to the other visuals on the page should not affect the card calculation.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
94 | |
89 | |
35 | |
32 |
User | Count |
---|---|
153 | |
101 | |
82 | |
63 | |
52 |