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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Multiple Filters Within A Single Column

Scenario - Using PBI Desktop, I need to create a measure that counts specific values within a single column in a single table. The values are all text but there are a couple dozen different ones depending on the type of solution provided to customer's in a call center environment.  There will ultimately be 5 of these measures depicting five different categories of resolution. For example, the column values Customer Satisfaction, Parts Shipped, Onsite Resolution and Resolved-Onsite from the Case_Resolution column will be used to create the category (or measure) of Single Session Resolution(Phone). 

 

From various reading I've done, it seems using the double pipe as a multiple filter is the way to go instead of an OR statement. Seems like this should be fairly straightforward but the precise syntax to do this eludes me as I'm not a DAX/PBI guru. Not sure if I can just use the COUNT function or if I need to throw a CALCULATE in there as well.  I've tried numerous ways to get this done but get various syntax or "too many parameters passed to the FILTER function" errors. Ultimately, th 5 measures will be used to create a multiple line chart showing changes in the percentage of these categories over time.

 

image.png

 

Any guidance would be greatly appreciated.

 

Thank you.

 

1 REPLY 1
Anonymous
Not applicable

I would create a separate table with the values and their respective solutions and then use a lookupvalue formula in dax to lookup the resolution for each situation instead of trying to use complex filter/calculate formulas.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.