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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
latrous98
Frequent Visitor

measure to filter a matrix visual by rows targetting a specific category\row

I have a matrix of detailed data and I gather this information from among different tables in my model.
Knowing that I already created a summerise table for an intermediate level and I filter on it with another attribut(which is the second level subcategory in the matrix visual )
I want get to calculate a meausure that allow me to keep only the filtered elements that I get from the second table .
Knowing that I use a measure in that visual in order to get the data I want to keep
here is the code I use , and I only keep the row that give 1 value

Filtering =
Var maxVal = MAX('last_usage values'[Value])
Var maxVal2 = MAX('number_hours_usage values'[Value])
Var currentValue = MAX('Summary Table'[last_usage])
Var currentValue2 = MAX('Summary Table'[number_hours_usage])
RETURN
If( currentValue <= maxVal && currentValue2 <= maxVal2,
1,0)
so I want to write a similar measure to filter upon a matrix visaual
thanks in advance 
2 REPLIES 2
amitchandak
Super User
Super User

@latrous98 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

data.PNG

table.PNG

the matrix visual get the order laptop_code - A -B and as a subtotal for both A and laptop_code it get the min of C values 
Knowing that I select A in another table that it does also the min of C values and it uses another groupe and do it regardless of the values 
I can send an exemple of the summary table if needed

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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.