topic Re: Help with DAX in DAX Commands and Tips

Help with DAX

Anonymous — Sat, 04 Dec 2021 20:38:01 GMT

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?

Re: Help with DAX

AlexisOlson — Sat, 04 Dec 2021 20:45:04 GMT

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?

Re: Help with DAX

bcdobbs — Sat, 04 Dec 2021 21:01:55 GMT

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.

Re: Help with DAX

Anonymous — Sat, 04 Dec 2021 20:58:06 GMT

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

Re: Help with DAX

bcdobbs — Sat, 04 Dec 2021 21:03:55 GMT

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

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