Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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 May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
66 | |
44 | |
42 |
User | Count |
---|---|
47 | |
38 | |
28 | |
28 | |
27 |