FILTER text column to only return text results

[Anonymous]

I have a text column which I'm trying to write a measure for in order to filter it:

Brag Status Count = CALCULATE(MAXA('UNION'[audit_results.BRAG STATUS]),FILTER('UNION','UNION'[Column 34] in {"Audit Results"}))

However I keep getting numeric results

can someone help me get the text results for this?

Thanks

[Fowmy]

@Anonymous 

Can you try:

Brag Status Count = 
    CALCULATE(
        CONCATENATEX(VALUES('UNION'[audit_results.BRAG STATUS]),'UNION'[audit_results.BRAG STATUS],"|"),
        'UNION'[Column 34] = "Audit Results"
    )
 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[amitchandak]

@Anonymous , this should work try like

Brag Status Count = CALCULATE(MAX('UNION'[audit_results.BRAG STATUS]),FILTER('UNION','UNION'[Column 34] in {"Audit Results"}))

Can you share sample data and sample output in table format?