Measure with filter not propagating to table

[Anonymous]

Hi, 

I have made below measure which when used in a table should (in my world) show only filtered results.

MEASURE:

Number of succeeded executions = CALCULATE(COUNT(ExecutionLog3[ExecutionId]);

ExecutionLog3[Format] IN { "RPL"; "PBIX" };

ExecutionLog3[ItemAction] IN { "Render"; "ConceptualSchema" };

ExecutionLog3[Status] = "rsSuccess")

However, the table shows the entire dataset, regardless of the format, itemaction and status (the three filters).

Why is this happening? Why do not only results that fulfil the filter criteria display in the table?

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

Just adjust the formula by FILTER as below:

Number of succeeded executions =
CALCULATE (
    COUNT ( ExecutionLog3[ExecutionId] );
    FILTER (
        ExecutionLog3;
        ExecutionLog3[Format] IN { "RPL"; "PBIX" }
            && ExecutionLog3[ItemAction] IN { "Render"; "ConceptualSchema" }
            && ExecutionLog3[Status] = "rsSuccess"
    )
)

Regards,

Lin

[Anonymous]

I appreciate your feedback guys, although my question still remains unanswered. 

Why does the measure filter my table and display only rows with "RPL" for instance, but when I add another condition, "PBIX", the table displays all types of formats. Not just PBIX and RPL.

[Anonymous]

Nevermind guys, when I use the dax supplied by you the table filters as expected. 

How come my dax does not filter my table, but yours does?

[HotChilli]

This is not how measure filters work.

The measure is evaluated for each row in your table visual.

If you want to filter the visual, use the Filter pane or slicers.

[Anonymous]

Thanks for the reply!

What confuses me however is when I only have one condition, like "RPL", the measure does filter the table to only display RPL rows. But when I have two conditions the entire dataset is still displayed in the table. 

Below works, but not measure in the first post.

CALCULATE(COUNT(ExecutionLog3[ExecutionId]);

FILTER(ExecutionLog3; ExecutionLog3[Format] = "RPL"

[Anonymous]

Hi @Anonymous 

Number of succeeded executions = CALCULATE(COUNT(ExecutionLog3[ExecutionId]),filter(ExecutionLog3,

ExecutionLog3[Format] IN { "RPL"; "PBIX" } &&

ExecutionLog3[ItemAction] IN { "Render"; "ConceptualSchema" } &&

ExecutionLog3[Status] = "rsSuccess")

THis will display count of id with the filters.

Incase you want to filter out rows.

measure=IF(

MAx(ExecutionLog3[Format]) IN { "RPL"; "PBIX" } &&

(ExecutionLog3[ItemAction]) IN { "Render"; "ConceptualSchema" } &&

(ExecutionLog3[Status]) = "rsSuccess",1,0)

add this measure to visual level filter and set it  to 1.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.