Forum Discussion
popman1987
2 years agoRegular Visitor
Power BI Dax Filtering Question - Selecting all current and lower index values
Could someone please help me solve the below issue? i have the below table called "Skill Selection List": Skill Level Writing 1 Writing 2 Writing 3 Writing 4 Reading 1 ...
- 2 years ago
HI All,
Apologies if my request was confusing!
The measure i have requested a solution for is a variable in a larger measure, which eventually gets wrapped in COUNTROW
If anyone cares, this is the solution i ended up going with
VAR filtertable =
SELECTCOLUMNS( GENERATE
'Skills Selection List',
GENERATESERIES(1,''Skills Selection List',[Level],1))
"Skill",[Skill},
"Level",[Value]
)
lbendlin
Super User
2 years agoMeasures can only return scalar values. Are you sure your UX design will not be confusing to users?