Select measure based on report setting

[jacinto]

Hi all,

Basically what the title says, the measure I want to use in the report depends on settings the user filter on the home page. I have two measures Spend and Indirect, however, in some cases some users might want spend as total spend which is sum of Spend and Indirect. Now whether to include indirect in spend calculation depends on the settings. Here is how a approached it. 

Created a table (Selector Table) with spendType column of values  Total spend and Spend. I put one page as a setting page where users select which type of spend they want. 

Here is the measure I have.

spend=Switch(FIRSTNONBLANK('Selector Table'[SpendType],1),

"Total spend", [Spend]+ [Indirect],

"Spend", [Spend])

I put spend as measures on all visuals in all pages. What I want is now spend could be different values based on the selection. However, this selection works only on the setting page, not on any other page. On other pages it shows spend as  [Spend]+ [Indirect] no matter the selection is. What am I doing wrong here? Is there any better way of implementing this. Thanks in advance. 

[amitchandak]

@jacinto , This table slicer, should be present of all pages and should be in sync or should be a page level filter

[jacinto]

It should on page level filter and must be selected at each page? What I want is users to select that in the setting page. I have report setting page where I put the options in slicer. Now I want selection of that slicer to apply for the entire report

[v-xiaotang]

Hi @jacinto 

you can try this Sync slicers, then you don't need to select the slicer each page by using this function,

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicer...

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.