Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Subtraction Row wise

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 t...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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" 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak ,

     

    I got solution , thanks for your reply.