Measures Worked in Table 1 but Not in Table 2 ??

[baby_cabbage]

I'm having an issue with my [Days filter] in Power BI. It works fine in Table 1, but when I apply it as a visual filter in Table 2, it doesn't behave as expected.

The [Days filter] is supposed to return 1 when it matches the selected values in the [Items] and [Pages] slicers. I use it to control how many days are shown in my visual.

However, when [Days filter] is applied as a visual filter in Table 2, it suddenly stopped working!

In Table 2, if I remove the Date filter from the visual, the [Days filter] starts working correctly. The problem is that without the Date filter, the data doesn’t make sense anymore.

I'm not sure why this is happening. How can I get Table 2 to work properly while keeping the Date filter in place?

I've attached my Power BI file for reference. Any help would be greatly appreciated!

https://drive.google.com/file/d/1GVhtnsAN6302noBQWYTIqe53IXT5rZQ-/view?usp=sharing

[Anonymous · Accepted solution]

Hi @baby_cabbage ,

Add the 'Days' field to the matrix row and the [Days Filter] measure filter works as expected.

You can also hide the +/- icons in front of the row headers to make it look as if there is only the 'Date' field in the row.

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[baby_cabbage]

I can’t believe it actually works! You’re a genius, Dengliang. How have you figured this out?? I was so close to giving up on this problem.

Thank you immensely! 

[Anonymous]

Hi @baby_cabbage ,

Please refer to this blog.

Applying a measure filter in Power BI - SQLBI

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cabbage_Baby]

Thank you ! I will read it through