Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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%.
@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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
92 | |
86 | |
76 | |
64 |
User | Count |
---|---|
137 | |
113 | |
107 | |
98 | |
92 |