Forum Discussion

PC2790's avatar
PC2790
Community Champion
5 years ago

Custom KPI based on multiple parameters

Hello,

I have a requirement to create a front page based on the comparison of multiple stages(in my case there are 6) based on the Region and Field value.

The model looks like(only 1 table is there):

Field ValueRegionVolumesStage
FirstNameAmerica10S1
LastNameAmerica40S1
EmailAmerica50S1
PhoneAmerica4S1
BirthDateAmerica24S1
FirstNameAsia77S1
LastNameAsia45S1
EmailAsia46S1
PhoneAsia21S1
BirthDateAsia24S1
FirstNameAmerica10S2
LastNameAmerica40S2
EmailAmerica50S2
PhoneAmerica4S2
BirthDateAmerica24S2
FirstNameAsia77S2
LastNameAsia45S2
EmailAsia46S2
PhoneAsia21S2
BirthDateAsia24S2

 

The matrix I have created in the detailed view looks like:

 

 

Now on the front page, I want to show a consolidated picture or like an indicator that would show me green if the difference between the volumes at each stage is same, as in S6-S5,S5-S4,S4-S3,S3-S2,S2-S1 is 0, then green

otherwise red.

If it is red, it should show a quick visual for which region and for which field value the red value is showing.

I tried something based on guy in a cube video-https://www.youtube.com/watch?v=zHzSBNES6jE&t=337s

 

But I am not sure, how should I be able to compare the volumes of different stages keeping the Field Value and parameter in consideration as part of the calculation.

Probably I am not doing any justice to this :

 

   Does have any leads to implement it or any better idea where I can present it in a much better way?

 

Thanks

2 Replies

  • Kumail's avatar
    Kumail
    Impactful Individual

    Hello PC2790 

     

    If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick solution.

     

    You can send the sample .pbix file by adding it to your drive or dropbox and add the link here.

     

    Regards
    Kumail Raza

    • PC2790's avatar
      PC2790
      Community Champion

      Hello Kumail ,

       

      Here you go: Link

       

      As I cannot share actual data, I have created a dummy file for your reference.

       

      Thanks