Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Subtraction for Group BY (Unique UID)

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 i...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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.