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
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
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.