Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have a text column which I'm trying to write a measure for in order to filter it:
@Neill_
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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Neill_ , 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?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.