Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

top5

Hi everyone, i want to  filter top 5 by cost of material  and visualize it. The following DAX doesnt yield the desired result Top5 = TOPN(5; SUMMARIZE(Sheet1; Sheet1[Material];"devcosts"; SUM[cost...
Need Help
Show and Tell
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    6 years ago

    Anonymous 

     

    Try following

     

    Top5 =
TOPN (
    5,
    SUMMARIZE ( Sheet1, Sheet1[Material], "devcosts", SUM[costs] ),
    [devcosts], DESC
)
v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. thanks a lot!