Create measure to compare value between 2 measures

[Anonymous]

Dear,

Please your help on below issue.

I created 2 measure below:

Measure 1: Calculate % by type of Sub-product

Type	1	2	3	4	5
Sub product	10%	15%	25%	30%	20%

Measure 2: Calculte % by type with specific product:

Product	Type	Percentage of each type
A	1	5%
A	2	25%
A	3	30%
A	4	30%
A	5	10%
B	1	5%
B	2	15%
B	3	15%
B	4	20%
B	5	45%

Now I want to compare data by type of each product with the correlative type in Sub-product.

Ex: Product A - Type 1: 5% - compare with Type 1 of sub-product: 10%

     Product B-Type 3: 15% - compare with Type 1 of sub-product: 25%

If %Sub-product Type 1 - % Product A Type 1 >5% => result = 1,

If %Sub-product Type 1 - % Product A Type 1 <-5% => result = 2

Otherwise, result = 0

Could you please advise how can I create a measure as below.

Thanks very much!

[V-lianl-msft]

Hi @Anonymous ,

Unfortunately, I don't know your data model.

Can you provide some sample data based on your data model? It's better to share a sample pbix to let us know more about your scenario.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 
Please remove any sensitive data before uploading.

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

[Anonymous]

Hi Liang,

Thanks for your feedback.

I'd like to share link for my pbix: 

https://drive.google.com/file/d/1jBDYT_4amHnZPhd6J_t_GyqojRwP8Qu3/view?usp=drivesdk 

And more details about the current issue:

Appreciate your support, thanks a lot!

[V-lianl-msft · Accepted solution]

Hi @Anonymous  ,

This is the correct value, not the value in your previous screenshot.

Please refer to this sample pbix

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