Subtraction for Group BY (Unique UID)

[Anonymous]

Hi Team,

I need your help for below calulation part,

Expected Result : a_Remaining Stock 
formula : (UID in Stock - a_Prod_Total ) 
note : UID in Stock and a_Prod_Total both are calculated in new Measure 

Thanks,

KV's

[amitchandak · Accepted solution]

@Anonymous , The input table and ask is not matching.

But if you want an action on grouped data, these are the ways.

sumx(values(Table[UID]),[UID in Stock] -[a_Prod_Total])
sumx(summarize(Table,Table[UID],"_1",[UID in Stock] -[a_Prod_Total]),[_1])

If this does not help

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[AllisonKennedy]

@Anonymous  Please can you provide more information on what you want to do and what currently doesn't work/where you're stuck? 

You should be able to do this using a table visual and simply using the measures you already have, just remove all the other columns from the table so only UID and the measures are in the table - this will automatically group by that column for you.