How to combine two ratio to present in a report?

[pohan10566]

I have a table that have certificated of deposite from the 3 banks. Each bank provides different ratios for each saving amount. 

In the report. I would like to present the bank ratio in range, and at the same time redeem date with just a single ratio.

In this case, what dax should I use so the report could have these two kind of ratio at the same time? 

Any hints and tips greatly appreciated

[v-henryk-mstf]

Hi @pohan10566 ,

According to your needs, create a column through dax, refer to the following:

range =
VAR a =
    CALCULATE ( MIN ( 'Table'[Interest] ), ALLEXCEPT ( 'Table', 'Table'[Bank] ) )
VAR b =
    CALCULATE ( MAX ( 'Table'[Interest] ), ALLEXCEPT ( 'Table', 'Table'[Bank] ) )
RETURN
    a & "-" & b

Best Regards,
Henry

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

[pohan10566]

Thanks so much for your reply. 

Acutally, I would like the report to present the category of the "bank" with the range of rate, and category  "date" with single rate as you drill down using the minus symbol. 

ex. the rate of the right side circle replacing the rate of the left side circle. 

[v-henryk-mstf · Accepted solution]

Hi @pohan10566 ,

You can use the HASONEVALUE function to create a measure, refer to the following:

Measure = IF(HASONEVALUE('Table'[Interest]),MAX('Table'[Interest]),MAX('Table'[range]))

Best Regards,
Henry

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