Custom KPI based on multiple parameters

[PC2790]

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 Value	Region	Volumes	Stage
FirstName	America	10	S1
LastName	America	40	S1
Email	America	50	S1
Phone	America	4	S1
BirthDate	America	24	S1
FirstName	Asia	77	S1
LastName	Asia	45	S1
Email	Asia	46	S1
Phone	Asia	21	S1
BirthDate	Asia	24	S1
FirstName	America	10	S2
LastName	America	40	S2
Email	America	50	S2
Phone	America	4	S2
BirthDate	America	24	S2
FirstName	Asia	77	S2
LastName	Asia	45	S2
Email	Asia	46	S2
Phone	Asia	21	S2
BirthDate	Asia	24	S2

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

[Kumail]

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]

Hello @Kumail ,

Here you go: Link

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

Thanks