Help with DAX

[Anonymous]

Hi,

I just have started with DAX, and I would create my first measure, but something is wrong.

I have a comment "cannot find name of column".

Could you explain to me why is that?

[bcdobbs]

A really good place to start learning is this free video course:

https://www.sqlbi.com/p/introducing-dax-video-course/

[AlexisOlson · Accepted solution]

If you're writing a measure, then you can't refer to a raw column since it doesn't know which values from that column you want are, so you need to use some kind of aggregation.

Assuming there actually is a column named STATUS in the table 'EWW 2022', you can write

IF (
    SELECTEDVALUE ( 'EWW 2022'[STATUS] ) = "REALIZACJA",
    SUM ( 'EWW 2022'[TURNOVER] )
)

However, the error message associated with the common DAX mistake above is different.

Are you sure STATUS is actually a column on 'EWW 2022' and not a different table and that there aren't extra spaces or something similar in the name?

[Anonymous]

Thank you so much for your help!
It was exactly what I needed 🙂
I wanted to start with a simple function, and it turned out that it isn't as easy as I thought

[bcdobbs]

Were you trying to sum the turnover column only where the status of each row equaled REALIZACJA?

If so I think the following is what you want:

CALCULATE(
    SUM ( 'EWW 2022'[TURNOVER] ),
    'EWW 2022'[STATUS] = "REALIZACJA"
)

CALCULATE lets you add a filter in directly (amoungst other things!) rather than relying on a slicer etc.