topic Re: A simple question, for a newbi user in DAX Commands and Tips

A simple question, for a newbi user

Anonymous — Wed, 25 Mar 2020 11:21:08 GMT

Hey there,

i somehow with the help of the internet managed to get the maximum value of the sum by a category, followed by that scrpit:

max value = MAXX(SUMMARIZE(Products, Products[Category_Name], "rev", SUM(Products[rev])), [rev])

and im now trying to get the category name of that measure, and i have no idea how to do it.

that is the value that i got, and and i want to see which category it is.

thanks!!! 🙂

Re: A simple question, for a newbi user

Stachu — Fri, 27 Mar 2020 10:49:38 GMT

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5

Re: A simple question, for a newbi user

Anonymous — Sun, 29 Mar 2020 05:50:37 GMT

here is the example of the data i work with,

thanks

Re: A simple question, for a newbi user

az38 — Sun, 29 Mar 2020 11:37:21 GMT

Hi Anonymous

Maybe not the best solution but should work

create a rank measure

RankMeasure = RANKX(ALL(Products[Category_Name]),CALCULATE(SUM(Products[rev])),,DESC)

then your desired

TopCategoryMeasure = calculate( FIRSTNONBLANK(Products[Category_Name],1), FILTER(ALL(Products[Category_Name]),[RankMeasure]=1) )

Re: A simple question, for a newbi user

Anonymous — Sun, 29 Mar 2020 12:34:05 GMT

love u

thanks!