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 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

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.

4 Replies

  • 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.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    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.