Subtraction Row wise

[Anonymous]

Hi Team,

DAX - I want the result has below highlighted in green colour, 
Balance = Total sum of (uinque) UID Production - each Cat stock (row wise subtraction)

Slicer (Month) select any month then above concept work with month wise.

if I select the slicer "All" the following function should work,this function says when the same UID stocks should sum-up and subtracted with production,
if I select a particular months in the slicer the following function should work above concepts

Thanks,

KV's

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Please refer to my .pbix file.

If the result is not correct, the reason may be that our data models are different.

Please share a more detailed data model, including the columns used in the measures.

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

[amitchandak]

@Anonymous The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[Anonymous]

Hi @amitchandak ,

I got solution , thanks for your reply.

[Anonymous]

Hi Team,

if I select the slicer "All" the following function should work *=H10-SUM($J$10:$J$12)* this function says when the same UID stocks should sum-up and subtracted with production

 and if click a specific month then "UID stocks should sum-up and subtracted with production for that particular month"