Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
37 | |
31 | |
26 |
User | Count |
---|---|
95 | |
50 | |
43 | |
40 | |
35 |