Diffence between hole value and fitered value

[Andreas-Harlak]

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

[v-rzhou-msft · Accepted 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.