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
I have three columns in a table and we are using parameters to select the required column to the table.
Based on the selected column, I need to summarize and do some calculation.
I am stuck and unable to find how to make “VAR SUMMERISE” to work, this variable should summerize the selected columns only. I am using this to find the denominator.
It works fine when all three columns are selected, but I need to summerize based on the selected column
Parameter are [column names]: We have a slicer on the page
🔲Partnername
☑️partnerTYPE
☑️partnercountry
I need a syntax to summarize just the selected columns
Uniques = VAR sumfc = SUM(salary) VAR SUMMARISE = SUMMARIZE(Partnername, Partnercountry, partnerTYPE, "Average", sumfc) RETURN IF( OR( ISINSCOPE('Partnername'), OR(ISINSCOPE('Partnercountry'), ISINSCOPE(partnerTYPE)) ), SUM(salary), DIVIDE(sumfc, COUNTROWS(SUMMARISE)) )
Can add sample file, please give me permission
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 57 | |
| 44 | |
| 40 | |
| 21 | |
| 18 |