Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

FILTER text column to only return text results

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
2 REPLIES 2
Fowmy
Super User
Super User

@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



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

amitchandak
Super User
Super User

@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?

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.