Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
qwertzuiop
Advocate III
Advocate III

Need: static measure, filtered by date

Hello dear Power BI-Community

 

Following problem:

 

Let's assume this table:

qwertzuiop_1-1641392490524.png

 

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]

 

qwertzuiop_2-1641392700897.png

 

Work fine but:

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

Static Value should be 50 then

 

qwertzuiop_3-1641393040131.png

 

Thank you very much for your contribution.

 

Cheers

qwertzuiop

 

 

 

 

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

1 REPLY 1
Pragati11
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.