Sync two pages to reflect values on the 3rd page

[Anonymous]

I am calculating Margin from my model and I would like to calculate it via different pages.

Type: Type 1, Type 2, Type All (Type 1 + Type 2)

I have created Type 1 in one page, Type 2 in another page, and Type All in the last page.

When I change the "What if" parameter for the first two pages, I would like the resultant Type All to contain the new summation.

What method could I use to achieve this?

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

>> I have created Type 1 in one page, Type 2 in another page, and Type All in the last page.

You can use  Sync slicers, but it can't integrate the values in two slicers into one slicer. Solved: Whatif Parameter shared across pages - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

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

[Anonymous]

@v-xiaotang Thanks for your reply. This kind of feature is basic in Excel and Power BI hasn't housed this functionality. I am currently picking up data from Excel for this report. However, I have to export it back to Excel and create this requirement. 

Feels pointless to use Power BI for just some glorified charts.

Thanks anyway for the reply.👍

[v-xiaotang · Accepted solution]

Hi @Anonymous 

I thought of a workaround, you can try this,

this method is to achieve a similar effect by creating a virtual table,

for example, 

count = 
var _type1=ALLSELECTED(type1)
var _type2=ALLSELECTED(type2)
var _t3= UNION(_type1,_type2)
return COUNTX(_t3,[type1])

it returns the count of types you selected

sum_selected_sales = 
var _type1=ALLSELECTED(type1)
var _type2=ALLSELECTED(type2)
var _t3= UNION(_type1,_type2)
return SUMX(FILTER('Table','Table'[type] in _t3),[sale])

it returns the total sales of the types you selected

Best Regards,

Community Support Team _Tang

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

[Anonymous]

Hi @v-xiaotang , I am trying to replicate the solution, however, on Page 3, 

this is what appears. Could you help in knwing why this could be happening? Also, if you could share me the .pbix file, I can go through the settings and figure out my issue.

Thanks,

Aditya