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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ryker888
Frequent Visitor

Month over Month change quick measure ignoring slicer

I am trying to calculate the month over month change of a measure and using the built in Percent MoM% quick measure however the quick measure calcualtion is ignoring my slicer and I tried a few different things with the DAX the quick measure made for me but I can not seem to get it follow my slicer.  

This is the DAX in the measure

 

Redelivery Percent MoM% = 
IF(
	ISFILTERED('simpleredelivery'[ordercompletedate].[Date]),
	ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
	VAR __PREV_MONTH =
		CALCULATE(
			[Redelivery Percent],
			DATEADD('simpleredelivery'[ordercompletedate].[Date], -1, MONTH)
		)
	RETURN
		DIVIDE([Redelivery Percent] - __PREV_MONTH, __PREV_MONTH)

 

This is what a table is showing using the quick mesure and the slicer I have on the page, is there any way I can not show the % Change for December to make sure the data shown follows the slicer?

 

Power BI % Change.JPGDelivery Date Slicer.JPG

1 REPLY 1
v-danhe-msft
Employee
Employee

Hi @ryker888,

Based on my test, it could work on my side, could you please check if there is any ALL function with your measure [Redelivery Percent]?

Or could you please share your pbix file to have a test if possible?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.