Forum Discussion

bengtsson_peter's avatar
bengtsson_peter
Frequent Visitor
3 years ago

How to use Top N visual filter with Field parameter?

I have two field parameters: Parameter1 = { ("Year", NAMEOF('Dates'[Year]), 0), ("Month", NAMEOF('Dates'[Month]), 1), ("Week", NAMEOF('Dates'[Week]), 2) } Parameter2 = { ("Activity", NAMEO...
Need Help
johnt75's avatar
johnt75
Super User
3 years ago

Not sure if this will work, but try creating a measure as

Total time spent = SUM('MyTable'[TimeSpent])

and add that as a TOPN filter rather than the column.

Al_Grant's avatar
Al_Grant
Regular Visitor
1 year ago

This sadly didn't work for me