Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jeanL
Frequent Visitor

Display card based on measure and filter

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%. 

 

type.PNG

2 REPLIES 2
amitchandak
Super User
Super User

@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

Hi @amitchandak 

 

I receive the error as such. 

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.