Forum Discussion
Top n with multiple columns
Hello, I have been searching for the solution but cant been able to complete it. I have 1 table (X) which has columns Costs (and has cost A,B,C,D,E), Country, Year, YearMonth, Quarter, Brand...
NikhilChenna
Skilled Sharer
Skilled SharerHi Anonymous , i think the below solution will work for you.
1. Create a calculated meaure .
TOPN( 3,
VALUES( table1[Country] ),
CALCULATE( SUM(table1[Values] ) )
)
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Sadly no 😞
Error: Bringing a lot of values when expecting only 1