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

Syndicate_Admin — Fri, 23 Jun 2023 16:18:11 GMT

Good afternoon Community,

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

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

topic Show Specific Measure When Selecting the Intersection of a Double-Entry Box in DAX Commands and Tips

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