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...
Need Help
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