Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have written the below measure - and it works correctly in a table with all the Names as the primary dimension - but when I select a specific Name dimension - the TOTAL part doesn't seem to work, and it only evaluates the formula based on the current selections - I would like it to always show the same Quartile results regardless of Dimension selections.
if(aggr(All_Results,[Name]) <= fractile(TOTAL aggr( All_Results,[Name]), 0.25), '1Q - Bottom 25%',
if(aggr(All_Results,[Name]) <= fractile(TOTAL aggr( All_Results,[Name]), 0.5), '2Q - Top Half 50% ',
if(aggr(All_Results,[Name]) <= fractile(TOTAL aggr( All_Results,[Name]), 0.75), '3Q - Top 25%')))
HI @tm_burgers ,
I think it's because TOTAL only defines the scope of the aggregation, not the set of data over which the aggregation is performed. If you're looking to ignore selections, you'll have to combine the scope with set analysis. Take a look here:-
If you post your app or an example here, it'll be easier to help.