topic Re: FILTER text column to only return text results in DAX Commands and Tips

FILTER text column to only return text results

Anonymous — Mon, 10 Aug 2020 08:48:11 GMT

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

Re: FILTER text column to only return text results

amitchandak — Mon, 10 Aug 2020 09:38:18 GMT

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?

Re: FILTER text column to only return text results

Fowmy — Mon, 10 Aug 2020 09:42:17 GMT

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