Problem with Quartiles Calculation

Hi Anonymous,

You can add a calculated column to assign quartiles category of your values, then you can use aggregate mode count on quartile category field to get specific quartiles percent.

BTW, calculate column results can't dynamic changes based on filters. If you want to keep the filter effect on the calculation, you can use measure formula with a variable to manually summarize these categories and values and do aggravate on these variable tables to get specific values.

Notice: you can't directly apply multiple aggregates on measure formulas. It requires you to manually do summary in a variable table with summarizing functions, then you can package above variable table with iterator functions(e.g. sumx, averagex, maxx, minx...) to achieve multiple aggregates.

Regards,

Xiaoxin Sheng