Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumilative amount table

Hello hope you are doing well.

 

I would like to have a cumilative percentage  to show cumilatively, how many percentage of the total applications.

 

So basically, in the screen shot.  I would like to have  cumilative value.  The Channel Source IDs are random, I just clicked"Larger to Small" sign so they are sorted from large to small. Do you know how i can do it? 

 

I need to Sort them by Large to Small and show the cumilative value.

 

Thanks

 

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    Based on your description, you can create two columns as follows.

    Rank = RANKX('Sheet3','Sheet3'[Applications],,DESC)
    Cumulative_applications = SUMX(FILTER(ALL('Sheet3'),[Rank]<=EARLIER('Sheet3'[Rank])),'Sheet3'[Applications])/CALCULATE(SUM('Sheet3'[Applications]),ALL('Sheet3'))

     

    Result:

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

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

3 Replies

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

    Anonymous , Create a new measure like

    Divide(calculate(Sum(Table[application]), filter(allselected(Table), Table[channel_source_id] <= max(Table[channel_source_id]))), calculate(Sum(Table[application]),allselected(Table)))

     

    or

     

    Divide(calculate(Sum(Table[application]), filter(allselected(Table), Table[application] <= max(Table[application]))), calculate(Sum(Table[application]),allselected(Table)))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello amitchandak , first of all thank you for your initial help.

       

      However i would like to have a cumilative 'by the sort of APPLICATION value' not the source ID.

       

      So basıcally for example in this visual.

       

      First Measure value should be = 896,260

      Second measure value should be =1591,945 (896,260 + 695,685)

       

      I NEED TO SORT ''APPLICATION NUMBERs' from Large to Small, and make them show cumilatively. 

       

       Can we do somethıng with that? 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

    Based on your description, you can create two columns as follows.

    Rank = RANKX('Sheet3','Sheet3'[Applications],,DESC)
    Cumulative_applications = SUMX(FILTER(ALL('Sheet3'),[Rank]<=EARLIER('Sheet3'[Rank])),'Sheet3'[Applications])/CALCULATE(SUM('Sheet3'[Applications]),ALL('Sheet3'))

     

    Result:

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

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