Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |