Dax how to use column instead of measure

[ArtPriIi]

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]

)

[Anonymous · Accepted solution]

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.

[Greg_Deckler]

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

[ArtPriIi]

@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