Forum Discussion
Solved
Summarize Tables with TopN / RankX Help
Hello, I am trying to get a summarized table that filters the TopN / Rank for a given aggregation. For some detail, I have the following table of data: Table 1: "Encounters" Dept ID Encounter...
Hi ExcelMonke ,
Below is my table1:
Below is my table2 :
Below is my table3:
The following DAX might work for you:
Measure = CALCULATE( COUNTROWS(Encounters), FILTER(Encounters,Encounters[Encounter ID]<>BLANK()), ALL(Encounters) )The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ExcelMonke ,
Below is my table1:
Below is my table2 :
Below is my table3:
The following DAX might work for you:
Measure = CALCULATE(
COUNTROWS(Encounters),
FILTER(Encounters,Encounters[Encounter ID]<>BLANK()),
ALL(Encounters)
)
The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.