topic Re: Dax how to use column instead of measure in DAX Commands and Tips

Dax how to use column instead of measure

ArtPriIi — Sat, 17 Dec 2022 13:31:06 GMT

I am stuck here. I want to use in this dax query "handled-interactions-vw[xxx]" instead of the measure [team avg csat1]. How would the dax query look like?

Team Avg CSAT1 Latest Period =

IF( MAX('Period Selected'[Sort Order])= 1,

CALCULATE(

[Team Avg CSAT1],

star_date_filter_vw[d_filter] in VALUES(DimSlicer[Measure1])

[Team Avg CSAT1]

)

Re: Dax how to use column instead of measure

Greg_Deckler — Sat, 17 Dec 2022 14:33:00 GMT

ArtPriIi You need to wrap your column in an aggregation like MAX, MIN, SUM, etc.

Re: Dax how to use column instead of measure

ArtPriIi — Sun, 18 Dec 2022 21:26:54 GMT

Greg_Deckler How do I do that as i want those column as is. also 1 is a freetext field. is. I am not sure how the dax query would look like. I need some help on the dax qeury

Re: Dax how to use column instead of measure

Anonymous — Tue, 20 Dec 2022 09:12:24 GMT

Hi ArtPriIi ,

Try the following DAX:

Team Avg CSAT1 Latest Period = IF( MAX('Period Selected'[Sort Order])=1, CALCULATE( SUM('handled-interactions-vw'[xxx]), FILTER(ALL(star_date_filter_vw),'star_date_filter_vw'[d_filter] IN VALUES('DimSlicer'[Measure1]))), SUM('handled-interactions-vw'[xxx]))

If your expected results are not met, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

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