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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
VilmarSch
Post Partisan
Post Partisan

Problem with Number Filter in Measure

Why when I filter the week number other than number 1, the measure value of 134 disappears?

 

@Ritaf1983 can you help with this question?

PBIX Here 

 

Sem título.png

4 REPLIES 4
Idrissshatila
Super User
Super User

Hello @VilmarSch ,

 

I think there's a missing relationship in your model .

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




@Idrissshatila  thanks for the answer.

 

Relationship is already included.

PijushRoy
Super User
Super User

Hi @VilmarSch 

You applied Filter in measure as 1

Medida = CALCULATE ( [Qtde], dCalendar[Semana] = 1 )
Follow link - https://learn.microsoft.com/en-us/dax/calculate-function-dax 
For that reason, when you select any other value except 1, it is showing blank.

I am not sure, what you want to calculate Medida

Thanks
Pijush



Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





@PijushRoy  thanks for the answer.

How do I fix?

I need that when filtering, the 134 always shows

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.