How to show multiple measure in single measure

[Anonymous]

Hi experts,

I have 2 measure 

1- Units

2-Volume

I want to show this on slicer if I click on units then dashboard's data could change basis on units and if i click on volume then change on volume.

Please help me on this.

@Greg_Deckler @amitchandak @Tanushree_Kapse 

Thanks.

[Tanushree_Kapse · Accepted solution]

Hi @Anonymous ,

Try this measure:

Measure= IF(CONTAINS(Table[Slicer_column]) ="Units", Units, IF(CONTAINS(Table[Slicer_column])= "Volume", Volume))

I hope this helps.

If I answered your question, mark it as solution. Kudos are always appreciated.

Thanks!

[Anonymous]

Thank you so much tanushree. 

Actually I am too friendly with Tableau but facing issues in Power BI but now smoothly learning. 

[Anonymous]

I have created two measure like Unit and Volume

I want to show this on slicer so user can easily can see basis on Units or Volums after clicking one by one.

[Tanushree_Kapse]

@Anonymous ,

Create a new table... with two rows.

Units 

Volume 

Use this column in your slicer. 

Then use this measure in your visuals in values. 

Measure= IF(CONTAINS(Table[Slicer_column]) ="Units", Units, IF(CONTAINS(Table[Slicer_column])= "Volume", Volume))