Multiple metrics by single selection.

[Harish_Kumar]

Is there any way to show multiple metrics by single filter. Eg. I have to show spends, previous spends, spends difference under one filter of spends category. If i select spend then previous spends and spends difference also shows in the table.

[Anonymous · Accepted solution]

Hi @Harish_Kumar ,

Based on your problems, here are my answers.

I create a table at first.

Then I create three measures.

Spends = SUM('Table'[Spend])

Previous Spends =
CALCULATE ( SUM ( 'Table'[Spend] ), PREVIOUSMONTH ( 'Table'[Date] ) )

Spends Difference = 'Table'[Spends] - 'Table'[Previous Spends]

Next  select the slicer visual and let Spend in.

Best Regards

Yilong Zhou

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