Generate a Measure that replaces multiple filters in the "Filter Panel"

[Syndicate_Admin]

Hello Community, how are you doing?

The query I want to ask you is the following:

As the image shows, several filters are made from the panel, what I need is to generate a measure that applies those "several filters" and applies them to me.

I generated part of it but I can not make the one that says "Filter 2", I leave the formula, to see if they can help me finish it.

PUENTEOS_e =

WHERE PUENTEOS_e=

FILTER(

FILTER(

Active_Separate_SemCong,

Active_Separate_SemCong[ORG_CODE] = "And"

),

Active_Separate_SemCong[STATE]="Planning"

)

RETURN

COUNTROWS(PUENTEOS_e)

Thank you.

[johnt75]

Use Performance Analyzer to get the code generated for the visual you need and paste it into DAX Studio. That will show you all the filters being applied and you can copy the code you need.

[Syndicate_Admin]

// DAX Query
DEFINE
VAR __DS0FilterTable =
FILTER(
KEEPFILTERS(VALUES('Active_Separate_Overview'[PALABRA_CLAVE])),
OR(
SEARCH("MIT", 'Active_Separate_Overview'[PALABRA_CLAVE], 1, 0) >= 1,
SEARCH("PUENTEO", 'Active_Separate_Overview'[PALABRA_CLAVE], 1, 0) >= 1
)
)

VAR __DS0FilterTable2 =
TREATAS({"E"}, 'Active_Separate_Overview'[ORG FIRST LETTER])

VAR __DS0FilterTable3 =
TREATAS({"Planificacion"}, 'Active_Separate_Overview'[STATE])

EVALUATE
SUMMARIZECOLUMNS(
__DS0FilterTable,
__DS0FilterTable2,
__DS0FilterTable3,
"CountPALABRA_CLAVE", IGNORE(CALCULATE(COUNTA('Active_Separate_Overview'[PALABRA_CLAVE])))
)

It generates the following code for me but I do not know how to interpret it.

[Syndicate_Admin]

Great, thank you very much!!!