Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Running Total

Hi all,   This is my first post in this community and I have a problem that has been troubing me for some time now and I am curious, at this point, if it is even possible.   So, I have transactio...
Need Help
v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

Hi Anonymous,

 

If I understand correctly, what you need is to calculate the total among the customers selected by the slicer.

You can use ISFILTERED function to meet this.

You can try measure like:

IF(
    ISFILTERED([customers]),
    [Measure],
    BLANK()
)

 

Best Regards,
Link

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    You are not too far off from what I am trying to accomplish. Rather than a filter though, I want it to be more like a rank. So if a customer is selected, all other customers still show in the visual and you can watch their inventory drop because it is being allocated to the selected customer.

    • v-xulin-mstf's avatar
      v-xulin-mstf
      Community Support
      5 years ago

      Hi Anonymous,

       

      What is the calculation logic of  rank?

      Could you provide your expected output in format of excel?

       

      Best Regards,
      Link

       

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

    • v-xulin-mstf's avatar
      v-xulin-mstf
      Community Support
      5 years ago

      Hi Anonymous

       

      Is your issue solved?

      If you still have some question, please don't hesitate to let me known.‌‌

       

      Best Regards,

      Link

       

      Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!