Forum Discussion
Solved
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 ...
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]
)
Thank you for the reply!
I was hoping to get something similar to this but in a measure form, and the results to be something like this, as i wanted to later on use this virtual table in a UNION measure:
| Speaking | 1 |
| Speaking | 2 |
| Speaking | 3 |
| Listening | 1 |
| Listening | 2 |
i would appreciate any help!
As others have said, a measure can not return a table.
That's why I used CONCATENATEX to get a single value.