Add a global setting to never auto summarize
We have some reporting requirements that can involve pulling in hundreds of columns of data, yes we've suggested better ways to do this, but for some ingest feeds that's what came as the client requirement. This for one starts to get rather pokey, but it's extra annoying when PowerBI decides to summarize each field and you have to go in and tell it not to summarize for dozens of them. There should be a global setting to not summarize new columns you can toggle on and off once, like there's a pause updates feature.
RANKX with SUMMARIZECOLUMNS and Filter
Hi all, Here is a sample of my dataset, where: - Job: one job can have multiple tasks, and be executed more than once in a day (job timestamp repeated). - Task: multiple tasks happen within a job. - Job TimeStamp: date and time the job started. One job can have multiple executions within a day. - Job Date: date the job started. - Job Status: can be either G or C. - Unique Key: concatenation between Job and Job TimeStamp. Here is a table I constructed using the following measures: G = CALCULATE(DISTINCTCOUNTNOBLANK(Table1[Unique Key]),Table1[Job Status]="G") Distinct Count Unique Key = DISTINCTCOUNTNOBLANK(Table1[Unique Key]) %G = IF([G]>0,[G]/[Distinct Count Unique Key],0) Average = CALCULATE([Distinct Count Unique Key], REMOVEFILTERS(Table1[Job]))/CALCULATE(DISTINCTCOUNTNOBLANK(Table1[Job]),REMOVEFILTERS(Table1[Job])) What I want to do a ranking of those jobs that are above average and below average. The jobs that are above average (Distinct Count Unique Key > Average), I want to create a table that contains the following: On the other hand, for those below average (Distinct Count Unique Key < Average): This ranking should be filtered with a slicer by Job Date. Ranking = VAR SummaryTable = FILTER( SUMMARIZECOLUMNS(Table1[Job],Table1[Job Date], "job_executions",DISTINCTCOUNTNOBLANK(Table1[Unique Key]), "job_failed_aborted",CALCULATE(DISTINCTCOUNTNOBLANK(Table1[Unique Key]),Table1[Job Status]="G"), "pcte_job_failed_aborted",CALCULATE(DISTINCTCOUNTNOBLANK(Table1[Unique Key]),Table1[Job Status]="G")/DISTINCTCOUNTNOBLANK(Table1[Unique Key])), [job_failed_aborted]>0) RETURN RANKX(ALL(SummaryTable[job_name]),[pcte_job_failed_aborted],,DESC) But it is not working. Could you please help me out? Thanks a lot! Best, S
