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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
AlekseiIncaRail
New Member

Calculate Formula Shows filtered data

I have written a easy formula con dax usin calculate as follow 

  • equipo_measure = max(Equipos[codigo_equipos])

However, for some reason it is showing values for some categories does that have been filtered. Let me break it down. the column codigo_equipos is been usen to filter, but as we can see in the table it is showing valures for "equipo" THP-005 eventhough just THP-004 has been selected. This get fix when I remove "fecha_max" column which is the measure that I want help with.

 The columns come from the following tables

  • Equipo: Temperatura_Laboratorio
  • codigo_equipos: Equipos
  • equipo_measure: this is my dax measure

I guess that it can be fixed by adding some context functions to calculate but I already tried everything I could think of as allselected or selectedvalue and such. Tbh I dont get why it shows THP-005 when I add the measure. When I remove it it only shows THP-004 as shown in the second figure

 

 

AlekseiIncaRail_0-1676579266626.png

AlekseiIncaRail_1-1676579352358.png

 

AlekseiIncaRail_1-1676578709812.png

 

3 REPLIES 3
lbendlin
Super User
Super User

Please explain the reasoning for the bidirectional connection between the top two tables.

Hello, I was just trying different things. Even with one direction it is still the same

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.