Looking for a function that acts for a column like calculate does for measures.

[Weasel]

Hello everybody,

in the example below diagram A shows products. A shows products and is filtered on latest month.

I want to click on the on of the products and use it to filter diagram B.

You can see what happens when I click a products in diagram A, in screenhot 2.

It filters B on prdocut AND date (therefore we only see one dot). But I only want it to be filtered on product.

With calculate I can easily create a measure that return the value for the the last 12 months. But I could not create a column that ignores the date filter.

Is there a way to do this?

[v-yulgu-msft]

Hi @Weasel,

Since you are able to create a measure that return the value for the the last 12 months, ignoring the date filter, you can directly add this measure to line chart B, instead of putting a column.

Regards,

Yuliana Gu

[Weasel]

Sadly that didn't work. The 12 month measure just shows the value for 12 months as one dot in June.