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 ...
"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!

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