Use value of measure in another page to divide

[yaman123]

Hi, 

I have a measure in Page 1 which shows the YTD Volume when a date is selected in a slicer (sample date).

I have another measure in Page 2 which shows YTD Retirer Volume when a date is selected in another slicer (supply end date). 

I need a new measure which divides the results of YTD Retirer Volume /  results of YTD Volume. 

E.g

YTD volume in Page1 is 1000 between sample date 01/02/2021 and 28/02/2021

YTD Retirer Volume in Page2 is 500 between supply end date 01/02/2021 and 28/02/2021

500/1000 = 0.5 

TIA

[amitchandak]

@yaman123 , have you create a common date and other dimension tables. You can use common date table and analyze data with that

YTD volume= CALCULATE([volume],DATESYTD('Date'[Date],"12/31"))

YTD volume= CALCULATE([Retirer  volume],DATESYTD('Date'[Date],"12/31"))

or same table change date

calculate( calculate( [Retirer  volume],USERELATIONSHIP ('Table'2[Supply end date], 'Date'[Date])),DATESMTD('Date'[Date]))

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[yaman123]

@amitchandak 

I have two date columns in the table. I dont have a date dimension table as all the data is in this table. 

I only need the results from page 1 and divide by results in page 2? 

[Icey]

Hi @yaman123 ,

Did I explain it clearly? Are these methods applicable to your scenario?

Best Regards,

Icey

[Icey · Accepted solution]

Hi @yaman123 ,

For measures, the values are calculated based on the computing environment, Row Context and Filter Context. In your scenario, measures are on different pages and filtered by different slicers. So, we can't use the result of YTD Retirer Volume in Page2 directly. 

One method is to sync the "supply end date" slicer on Page1 and set it only affect a single visual which shows the result of your new measure which divides the results of YTD Retirer Volume /  results of YTD Volume. And the filters on Page2 may need to set again.

If the sample date and supply end date slicers are always set in the same period, another method is to create a date dimension table and create create relationships between 'yourfacttable'[sample date] and 'datedimensiontable'[date], 'yourfacttable'[supply end date] and 'datedimensiontable'[date]. Both of the two relationships are inactive and use USERELATIONSHIP function (DAX) to "active" the one needed in measures. Then, we can use only one slicer to filter both sample date and supply end date. 

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.