Forum Discussion

DARKLOARD's avatar
DARKLOARD
Frequent Visitor
2 years ago
Solved

Use a single value to return multiple metric in bar chart?

Hello all!

I have a question, I have a dataste set which looks into sum of Savings Balance for Dec'23 and for Mar'24. 

I have it summed up and displayed like this in bar

Now I need to add a Fixed Deposit metric also that again look into sum for Dec'23 and Mar'24.

I figured that having a filter that I can use to switch between Saving Account and Fixed Deposit metric for two dates would be smart, but I cant seem to form a filter that works.

 

I made a new table called Measure Table with the below column, with these options,

then a new measure, but it doesnt work. I think im missing something but not sure if theres a way to create a filter that shows value for Savings & FD.

 

SA = IF(CONTAINS('Measure Table', 'Measure Table'[Metrics], "CASA"), [DEC'23], [Mar'24])

 

 

If any help that would be great! 

Thank You!

 

 

"DAX Query View"
"FILTER"
"MEASURE"
Metric Switch
  • DARKLOARD's avatar
    DARKLOARD
    2 years ago

    I was able to update the base file to include identifier for CASA & FD. Hence using these identifier as the filter for the 2 years.

    Was able to resolve this issue!

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi DARKLOARD ,

    Please have a try.

    Create a measure.

    Dynamic Metric Value = 
VAR SelectedMetric = SELECTEDVALUE('Measure Table'[Metrics], "Default")
RETURN
IF(
    SelectedMetric = "CASA",
    CALCULATE(SUM('DataTable'[SavingsBalance]), 'DataTable'[Date] IN {"Dec'23", "Mar'24"}),
    CALCULATE(SUM('DataTable'[FixedDeposit]), 'DataTable'[Date] IN {"Dec'23", "Mar'24"})
)

     

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

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

     

     

     

     

    • DARKLOARD's avatar
      DARKLOARD
      Frequent Visitor
      2 years ago

      Hey thanks for the response, some quetions

      • The field below is something I will have to create I suppose? Combination of 23+24 numbers? 
        (SUM('DataTable'[SavingsBalance])​
      • And i suppose I should have been more clear, these two fields contain the amount per customer for that month year
        'DataTable'[Date] IN {"Dec'23", "Mar'24"})​

       

      So Dec'23 & Mar'24 look like this, no date but actual amount

  • DARKLOARD's avatar
    DARKLOARD
    Frequent Visitor
    2 years ago

    I was able to update the base file to include identifier for CASA & FD. Hence using these identifier as the filter for the 2 years.

    Was able to resolve this issue!