Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
floppysock
Frequent Visitor

Multi card measures - this week and last week sums

Hi all, 

I have a page in powerbi that has a page level filter - this filters all of the kpis and metrics to show data for a single week (start_of_week. The user can select which week data to view using the filter. 

However I want to add a multi label cards so that the kpis for this week are shown, but underneath has the change (be it a % change or volume change) compared to last week. 

Is it do-able to write measures that will ignore the page filter and do the same measure but for start_of_week - 7?

1 REPLY 1
floppysock
Frequent Visitor

Update - I've managed to make a measure that ignores the column filter using REMOVEFILTERS, however I don't know how I'd then apply another filter to the measure to get the data for start_of_week - 7?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.