Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
our report page shows us a hole value of 21 Mio €
Now we can use the filter "Filter Liferant" and get the value of one supplier.
With this filter activated we get the value of 2 Mio €.
Now we want a card wich shows us the % Difference to the total of only ignore the filter "Filter Lieferant", the other two filters "Auswahl" and "GJ" must be present.
So that the solution is like this
I hope somebody can help me thanks a lot
Solved! Go to Solution.
Hi @Andreas-Harlak ,
Due to I don't know your data model, here I will give you some suggestions.
% Difference =
VAR _IgnoreFilter =
CALCULATE (
[Measure in Bestevolumen Card],
REMOVEFILTERS ( 'TableName'[Filter Lieferant] )
)
RETURN
DIVIDE ( [Measure in Bestevolumen Card], _IgnoreFilter )
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Andreas-Harlak ,
Due to I don't know your data model, here I will give you some suggestions.
% Difference =
VAR _IgnoreFilter =
CALCULATE (
[Measure in Bestevolumen Card],
REMOVEFILTERS ( 'TableName'[Filter Lieferant] )
)
RETURN
DIVIDE ( [Measure in Bestevolumen Card], _IgnoreFilter )
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |