create a measure that keeps filters

[Anonymous]

Hi,

Take the following schema as an example:

Let's say I build the following report where i filter the data table by the week table:

if i create a measure (let's say Measure=1), how can i build it so that it keeps existing filters (unlike below example)?

please keep in mind that this is just an example: my real-life dashboard has many more tables and filters involved.

Thanks

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

The Product Team have replied me that the problem is by design.

A filter is applied in two cases: (1) The filter applies to any columns from the same table. (2) The filter applies to all measures and afterwards the measure values will filter the columns by removing rows where measure values are all BLANKs. In this case, the filter is on the 'week' table, therefore doesn't apply columns from the 'data' table. On the other hand, the measure expression ignores all filters and always returns a non-BLANK value, therefore the indirect effect of preserving rows only with non-BLANK measure values will preserve all rows. The net effect is that the slicer has no impact on the table visual. When a measure is not added to a table visual, Power BI injects a hidden measure that's similar to CountRows('data') which is filtered by the slicer and then indirectly filter the result.

Hope it could help you.

Regards,

Daniel He

[v-danhe-msft]

Hi @Anonymous,

The problem has been reported internally, I will update here once I get any information. 

Regards,

Daniel He