Forum Discussion

Harish_Kumar's avatar
Harish_Kumar
New Member
2 years ago
Solved

Multiple metrics by single selection.

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.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.