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
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
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.