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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Linking Revenue Matrices for Comprehensive Customer Insights

Hello,

I have two matrices side by side. The right matrix shows revenue across all months by customer, while the left one only displays revenue for the last two closed months by customer(april is not closed now). When I click on a customer in the left table, I want the right table to show revenue across all months for that customer.

Can you help me?

CesarBoldrino_0-1712840253131.png

CesarBoldrino_1-1712840283258.png

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

solved! 

var _diff = CALCULATE(sum(View_Forecast_Revenue[Revenue]),View_Forecast_Revenue[FRE_Periode] = _CurrentPeriode,dim_Calendar[IsLCM]= 1,ALL(dim_Calendar)) -CALCULATE(sum(View_Forecast_Revenue[Revenue]),View_Forecast_Revenue[FRE_Periode] = _CurrentPeriode,dim_Calendar[IsPreLastClosedMonth]=1,ALL(dim_Calendar))

Return IF(ISINSCOPE(dim_Calendar[ShortMonthName]),CALCULATE(sum(View_Forecast_Revenue[Revenue]),View_Forecast_Revenue[FRE_Periode] = _CurrentPeriode,dim_Calendar[IsM2M]= 1),_diff)

View solution in original post

1 REPLY 1
Anonymous
Not applicable

solved! 

var _diff = CALCULATE(sum(View_Forecast_Revenue[Revenue]),View_Forecast_Revenue[FRE_Periode] = _CurrentPeriode,dim_Calendar[IsLCM]= 1,ALL(dim_Calendar)) -CALCULATE(sum(View_Forecast_Revenue[Revenue]),View_Forecast_Revenue[FRE_Periode] = _CurrentPeriode,dim_Calendar[IsPreLastClosedMonth]=1,ALL(dim_Calendar))

Return IF(ISINSCOPE(dim_Calendar[ShortMonthName]),CALCULATE(sum(View_Forecast_Revenue[Revenue]),View_Forecast_Revenue[FRE_Periode] = _CurrentPeriode,dim_Calendar[IsM2M]= 1),_diff)

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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