Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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),
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.
Hi @jacinto ,
Try using this measure,
Dynamic measure= IF(Contains(SelectorTable(Spend Type) = "Spend", [Spend],
IF(Contains(SelectorTable(Spend Type) = "Total Spend", [Spend]+ [Indirect]))
Pull this measure in all your visuals on the page.
And the selectortype column in the slicer for selections.
Mark this as a solution if I answered your question. Kudos are always appreciated.
Thanks
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |