Forum Discussion

popman1987's avatar
popman1987
Regular Visitor
2 years ago
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 ...
Need Help
  • popman1987's avatar
    popman1987
    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's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Not possible. You must consume the virtual table inside the measure. Measures can only return scalars.

popman1987's avatar
popman1987
Regular Visitor
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]
)