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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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