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
Syndicate_Admin
Administrator
Administrator

Show Specific Measure When Selecting the Intersection of a Double-Entry Box

Good afternoon Community,

I have a problem, I need please help me with the following logic, the double entry box which is as follows:

paullarana_0-1687536564178.png

Make a measurement which works very well for me when I select a row or some columan or when none of them is selected:

Measure = IF(
ISFILTERED(Hoja1[system]),
SWITCH(
TRUE(),
VALUES(Hoja1[system])="BANKS",SUM(Hoja1[tasa_x_banco]),
VALUES(Hoja1[system])="CMACS",SUM(Hoja1[tasa_x_banco]),
VALUES(Hoja1[system])="CRACS",SUM(Hoja1[tasa_x_banco]),
VALUES(Hoja1[system])="EDPYMES",SUM(Hoja1[tasa_x_banco]),
VALUES(Hoja1[system])="FINANCIAL",SUM(Hoja1[tasa_x_banco])
),
IF(
ISFILTERED(Hoja1[category]),
SWITCH(
TRUE(),
VALUES(Hoja1[category])="Consumption",SUM(Hoja1[tasa_Catego]),
VALUES(Hoja1[category])="Loans to large companies",SUM(Hoja1[tasa_Catego]),
VALUES(Hoja1[category])="Loans to medium-sized enterprises",SUM(Hoja1[tasa_Catego]),
VALUES(Hoja1[category])="Loans to Microenterprises",SUM(Hoja1[tasa_Catego]),
VALUES(Hoja1[category])="Small Business Credits",SUM(Hoja1[tasa_Catego]),
VALUES(Hoja1[category])="Corporate Credits",SUM(Hoja1[tasa_Catego]),
VALUES(Hoja1[category])="Mortgage Loans",SUM(Hoja1[tasa_Catego])
),
AVERAGE(Hoja1[Column])
))
The jam I have is when I select some value of the intersection of the rows or columans, I need to show you another field in thickening, I do not know if it has to do as a new measure using the one I already have or if it can be done in the same measure.
Best regards

0 REPLIES 0

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.