Forum Discussion

Jennifer2018's avatar
Jennifer2018
Regular Visitor
8 years ago

Percentile Category

Hi,   I am trying to categorize my percentile as below but kept on coming with value of Q4.   Can you please check what is wrong?   Thanks :)   PercentileCategory = //find cutoff points for ...
Jennifer2018's avatar
Jennifer2018
Regular Visitor
8 years ago

Thanks Greg_Deckler.

 

Question tho, I dont have a "Percentiles table". The table I provided is table I created from different tables in my data - branch from branch table, date from date table, AHT is a measure calculated from branch activity table.

 

Do I need to make a table then? The table and graph will be on a report page with date and branch slicer. Can the percentile category change dynamically when I change the date and branch slicers?

 

I also want to include a hierarchy in the branch slicer, can  the percentile category accomodate that?

 

Thank you very much for your help. :)

 

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Ah, see this is why posting source data and model is important. In your case, what you are trying to do is an aggregation of a measure. That generally means that you need to construct a "temp table" in your measure using something like ADDCOLUMNS or SUMMARIZE or some combination. Can get tricky when multiple tables are involved. Basically, you would create a VAR where you would store that temp table. 

 

See the article I have on it:

 

This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149