Forum Discussion

Periksson's avatar
Periksson
Frequent Visitor
7 years ago
Solved

SELECTEDVALUE ALTERNATERESULT

I have made a new measure that will give me only selected top N from the list of goods ranging from 5 to 100 e.g. The ALTERNATERESULT in SELECTEDVALUE is default BLANK() so it shows an empty list of...
DAX
DAX filter formula
dax functions
  • tarunsingla's avatar
    tarunsingla
    7 years ago

    Try this:

    Selected N = SELECTEDVALUE('Select Top N'[Select N], COUNT(wrhsSales[Goods]))

tarunsingla's avatar
tarunsingla
Solution Sage
7 years ago

Try this:

Selected N = SELECTEDVALUE('Select Top N'[Select N], COUNT(wrhsSales[Goods]))