Need: static measure, filtered by date

[qwertzuiop]

Hello dear Power BI-Community

Following problem:

Let's assume this table:

The goal is to calculate the % value of Orders (Anz. Aufträge) per product

Doing this by following two Measures:

Static = CALCULATE(SUM('Tabelle'[Anz. Aufträge]),ALL('Tabelle'))

%-Anteil = Tabelle[Anz. Aufträge Tot] / Tabelle[Static]

Work fine but:

Static Value remains static even if date filter is applied (see picture 2)

Static Value should be 50 then

Thank you very much for your contribution.

Cheers

qwertzuiop

[Pragati11 · Accepted solution]

Hi @qwertzuiop ,

If I understand correctly, you want your static measure to change only on Date filter.

Based on this you can modify your DAX for static measure as follows:

Static =
CALCULATE (
    SUM ( 'Tabelle'[Anz. Aufträge] ),
    ALLEXCEPT ( 'Tabelle', 'Tabelle'[Datum] )
)

Thanks,

Pragati