New Table with value from Measure

[NithinBN]

Hello,

I have 4 measure with values  Prod_A_Tar=500K, Prod_B_Tar=800K, Prod_A_Act=300K,Prod_b_Act=960K,

I want to build table like this,

Product	Tar	Act	Dist
A	500	300	60
B	800	960	120
Total	1300	1260	97

Dist is (Act/Tar)*100, 

How I can achieve this kind of visualization ?

[v-kelly-msft]

Hi @NithinBN ，

You need first to merge measure [Prod_A_Tar] and [ Prod_B_Tar] into one measure as Prod_Tar,then  merge [Prod_A_Act] and [Prod_A_Act] into another measure as Prod_Act.Finally,create a measure [Dist].

If  you still cant figure out,could you pls upload your .pbix file to onedrive business and share the link with me?

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!