Forum Discussion

EpicTriffid's avatar
EpicTriffid
Icon for Helper IV rankHelper IV
3 years ago

Isolating values from specific column in matrix

Hi all,   Bit of a difficult one to explain this, but in the screenshot below, I am attempting to calculate the difference between forecasted student numbers in the future, and the actual financial...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi EpicTriffid 

Did you create the dax in measure, you can try to put the dax in a measure, then put the measure to the matrix

 

 

measure=
CALCULATE(
    SUM('Base Data'[Total Student Count]), 
    ALLEXCEPT(
        'Base Data', 
        'Base Data'[Department],
        'Base Data'[Faculty],
        'Base Data'[Mode and Code],
        'Base Data'[Course Mode],
        'Base Data'[Fee Status],
        'Base Data'[Course Title],
        'Base Data'[Forecast/Actuals],
        'Base Data'[Course Level (Grp 2)], 
        'Base Data'[Course Level (Grp 1)], 
        'Base Data'[Numbers Type]),
    'Base Data'[Course Year of Study] = 1, 
    'Base Data'[Year Index] = 3)

 

 

If it cannot work, can you provide sample pbix file?

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.