Conjunto de opciones MultiSelect Filtro D365 con contiene consulta

[PowerBITesting]

FILTRO en varias tablas con contiene - No funciona

Count- CALCULATE(

COUNT(activity[createdon]),

FILTER(citas, citas[Filed1] contiene "100") O

FILTER(CONTAINS(phonecall,phonecall[Filed2],"200")OR

FILTER(CONTAINS(tareas,tareas[Filed3],"200")

)

citas, llamadas telefónicas y tareas todas son hijas de La actividad.

y Filed1 ,Filed2 y Filed3 son el conjunto multiopción D365

[v-xuding-msft · Accepted solution]

Hola @PowerBITesting ,

Podrías intentarlo así:

Column =
VAR app_id =
    CALCULATE (
        FIRSTNONBLANK ( appointments[ID], 1 ),
        FILTER (
            VALUES ( appointments[Filed1] ),
            SEARCH ( "100", appointments[Filed1],, 999 ) <> 999
        )
    )
VAR pho_id =
    CALCULATE (
        FIRSTNONBLANK ( phonecall[ID], 1 ),
        FILTER (
            VALUES ( phonecall[Filed2] ),
            SEARCH ( "100", phonecall[Filed2],, 999 ) <> 999
        )
    )
VAR task_id =
    CALCULATE (
        FIRSTNONBLANK ( tasks[ID], 1 ),
        FILTER (
            VALUES ( tasks[Filed3] ),
            SEARCH ( "100", tasks[Filed3],, 999 ) <> 999
        )
    )
RETURN
    COUNTROWS (
        FILTER (
            activity,
            activity[app_id] = app_id
                || activity[pho_id] = pho_id
                || activity[task_id] = task_id
        )
    )

[amitchandak]

@PowerBITesting , Probar como

Count- CALCULATE(
COUNT(activity[createdon]),
OR(OR(appointments[Filed1] contains "100") , CONTAINS(phonecall[Filed2],"200") , CONTAINS(tasks[Filed3],"200"))
)

[lbendlin]

DAX utiliza el uso de la estación de para la lógica "o" y && para la lógica "y".