Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Average based on the Bucket

Hi All

 

I am currently trying to calcualte the measure to achieve the average amount for the buckets that i have catergoried after step 2 below, currently the measures i have created as step 3 has not resulted in the desired outcome i was hoping. The end goal is to get the Average pay for each bucket and create a histogram so the distribtuion can be visualised in the bucket form. 

 

Step 1

RDP= RANKX(ALL('Table'),CALCULATE(Max('Table'[Pay])),,DESC,Dense)
Step 2 
DPB = ROUNDUP(([RDP]/5),0)
Step 3
DPBA = CALCULATE(AVERAGE('Table'[Pay]),MAX([DPB])=[DPB])
 
 
 
Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,
    Based on your description and the formula provided, you want to go ahead and create a MEASUREMENT to calculate the average salary for each storage bucket and create a histogram, you can try this formula below, he for the salaries are categorized by group and then the average is calculated within the group.

    DPBA = 
CALCULATE(
    AVERAGE('Table'[Pay]),
    ALLEXCEPT('Table', 'Table'[DPB])
)


    If this issue is not resolved, you can provide full example data and expected results so we can help you faster. Please hide your sensitive information in advance.

    Best regards,

    Albert He

     

    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
      2 years ago

      Hi, 

      ALLEXCEPT('Table', 'Table'[DPB])

      isnt working since "DPB" is a measurement not a calculated column. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous ，
        Because we have no way of knowing how your exact MEASURE was created. Please provide full example data and expected results so we can help you faster and hide your sensitive information in advance.

        Best regards,

        Albert He

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

    Hi,

    Are the buckets something like 1-5, 6-10,11-15 etc?  If yes, then till where should this table go?  If my understanding is correct, then share some data to work with.