Subtraction Row wise Calculation

Hi  Anonymous  ,

According to your description, I create this data：

Here are the steps you can follow：

1. Create measure.

Stock: Cat category value when uid is consistent

stock =
CALCULATE(SUM('Table'[amount]),FILTER('Table','Table'[Cat]=MAX('Table'[Cat])))

sal_total：Sum by [cat] class UID

sal_total =
var _UID=CALCULATE(MAX('Table'[UID]),FILTER(ALL('Table'),[Cat]=MAX('Table'[Cat])))
return
CALCULATE(COUNT('Table'[UID]),FILTER(ALL('Table'),'Table'[UID]=_UID))

Blac_Manual：Expected results

Balc_Manual = [stock]-[sal_total]

2. Result

You can downloaded PBIX file from here.

If my answer is not what you need, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Best Regards,

Liu Yang

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