Display card based on measure and filter

[jeanL]

I have created a measure to calculate the percentage of the amount by the total (filtered by main services)

My measure calculation is as follow

% teu by service = 
VAR teu = CALCULATE( SUM(summary_table[Total TEUs]))
VAR t_total =
    CALCULATE(
        CALCULATE( SUM(summary_table[Total TEUs])),
        ALLSELECTED( summary_table[control_party_name]))
VAR result = DIVIDE(teu , t_total)
RETURN
    result

While at the same time, the report has several filters, in customer segment, main services and control party name. 

In this case, the above only returns % over the total by main service. 

However i would like the option to be able to select the control party name, in which a card would display the respective % exposure.

The rows below is by control party name. So example if i select the control party name of the first row, example A, it would show 67% on the card instead of the 100% and B would return 18%. 

[amitchandak]

@jeanL , Please use an independent table control_party_name  slicer

% teu by service =
var _control_party_name = allselected(control_party_name[control_party_name])
VAR teu = CALCULATE( SUM(summary_table[Total TEUs]))
VAR t_total =
CALCULATE(
CALCULATE( SUM(summary_table[Total TEUs])),
filter(summary_table, summary_table[control_party_name] =_control_party_name ))
VAR result = DIVIDE(teu , t_total)
RETURN
result

refer

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

[jeanL]

Hi @amitchandak 

I receive the error as such. 

A table of multiple values was supplied where a single value was expected.