I am trying to figure out how to calculate the following count and median for a data set with recurring rows. What would the measure syntax be to achieve the results on the bottom right of the image? Thanks in advance!
Go to Solution.
You can create a summarized table
SumTable = SUMMARIZE(Table2, Table2[ProjNbr], "Revenue", MAX(Table2[Revenue]))
For the count, you don't have to create the table explicitly:
SUMMARIZE ( Table2, Table2[ProjNbr], "Revenue", MAX ( Table2[Revenue] ) )
)orCnt = COUNTROWS (SumTable)
But for the median I don't think you can avoid creating the table as MEDIAN requires a column name
Mdn = MEDIAN(SumTable[Revenue])
Hope this helps.
View solution in original post
Thanks, David. That was extremely helpful!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.