Forum Discussion

KKhurana's avatar
KKhurana
Frequent Visitor
6 years ago

Create a chart containing calculated measure showing comparison of two insurers

Hi, 

 

I need to create a Y-o-Y chart showing the comparison of the loss ratios for two different insurers. 

The dataset I have has a list of multiple insurers with their premiums and incurred losses. I aim to create two slicers such that one has the option of selecting any one of the insurers (Main Insurer) and the other slicers shows the comparison insurer which can be selected from the same list of insurers. I have created a new column in my table named as 'Comparison Insurer'. 

 

However, when use the dax function to calculate the loss ratio = Calculate(sum(Pivotcopy[Gross incurred claims])/sum(Pivotcopy[Gross earned premium])), it only gives me the loss ratio of the Main insurer. I need to create a new measure such that now the loss ratio is based on the Comparison Inusrer selected. 

 

Is there some DAX formula i can use to only see the selected slicer option?

 

Thanks in advance for your help!

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi KKhurana ,

     

    To make this happen you can make use of two different options:

    • Use a single slicer and select both values from that slicer and then using MAX and MIN value to filter the calculation to get each of the insurers
    • Use two disconnected tables to make the slicers and then making use of SELECTEDVALUE pick up the information and compared it to your data.

    can you share some sample data