Forum Discussion

Millser's avatar
Millser
New Member
5 years ago
Solved

Running total for power Bi

Hi, I have a table which contans a bunch of values that correspond to behaviours (Green = 1, Yellow = 0.25, Orange = 0, Absent = 0 suspended = Clear all points and Warning = halve the points) and a ...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Millser,

     

    If the value is 'clear', what the calculation logic of your expected output?

    You can try measure as:

    IF(
   max'table'[value]="Clear",
   [logic of 'clear']
   [logic of running total]
)

    If you still have some question, please provide the sample data and expected output.‌‌

     

    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!

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Share some data and show the expected result.

  • Millser's avatar
    Millser
    New Member
    5 years ago

    The expected result that that beside the name of the student would be their behaviour and running total. However I cannot seem to calculte this running total becasue one of my values is called "clear" and it is not numeric, I am unsure how to express this as a numeric value in order to calculate it.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      Hi,

      Please show the raw data and the expected result.

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

      Hi Millser,

       

      If the value is 'clear', what the calculation logic of your expected output?

      You can try measure as:

      IF(
   max'table'[value]="Clear",
   [logic of 'clear']
   [logic of running total]
)

      If you still have some question, please provide the sample data and expected output.‌‌

       

      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!