Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Any guidance would be greatly appreciated.
Thank you.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 137 | |
| 102 | |
| 68 | |
| 66 | |
| 64 |