% of Total is not working with parameter

[Anonymous]

Hi, Power BI community!

I have a Power BI dashboard with a group of Bar charts with dynamic field in the legend (there are two values) and I have a measure which calculates the % of total for this charts (this parameter in legend is not used in the calculations)

Here is the measure:

% of Total by Market = DIVIDE([Revenue Exchanged], CALCULATE([Revenue Exchanged], ALLEXCEPT(Table1, Table1[market])),0)

The problem is, when I switch the legend parameter, this calculation stops working, so it works only with the first value, but shows 100% for everything when parameter value is changed, could someone help with that?

Here is the parameter:

Bar charts parameter = {

("Group1", NAMEOF('Table1'[field1]), 0),

("Group2", NAMEOF('Table2'[field2]), 1)

}

Thanks in advance!

[Anonymous · Accepted solution]

Hi Everyone, I found a solution to this:

% of Total by Market =

IF

(SELECTEDVALUE('Parameter name'[Parameter Fields]) = "'table1'[field1]",

DIVIDE([Revenue Exchanged c], CALCULATE([Revenue Exchanged c], ALLEXCEPT(table1, table1[market]))),

DIVIDE([Revenue Exchanged],CALCULATE([Revenue Exchanged],ALLEXCEPT(table2,table2[market]))))

Working with parameters can be tough sometimes

[Anonymous]

Hi @Anonymous ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng