chart to ignore one selection in sheet

[Heny]

Hi,

I know this should be done with alternate state or set analysis but I just cannot get it right.

I have a sheet with 2 chart - a table chart showing full data and a line chart of avg work time by month.

I have a few filters on the sheet  - Customer, product, product_line, month

I want the table chart to filter according to all selections but in the line chart I want to keep showing all the months even if user selected a certain month.

how do I go about this?

[brunobertels]

Hello 

Using 1 will ignore all selections:

ex:

sum({1<Category = {'category1'}>}[Number of people])

If you only want to ignore selections in a particular field, you would do it this way:

sum({$<Category = {'category1'}, IgnoreField =>}[Number of people])

[Heny]

thanks for your reply

what is the "IgnoreField"?

[VBD]

Hello, "ignorefield" are the fields that you don't want to include in your selection,

For exemple, if a use :

sum({$<Category = {'category1'}, Month=>}[Number of people])

In my table, the filter "Month" will not be applied.

For exemple, if a use :

sum({$<Category = {'category1'}, Month=,Year=>}[Number of people])

In my table, filters "Month" and "Year" will not be applied.

Regards

[Heny]

thanks, got it.

but this will only be applied to "category1"?

i don't want to limit only to one category

[VBD]

It's just an exemple, it's not necessary 

[Heny]

yes, I understood that. Can you help me apply this to my model?

my line chart has 1 dimension and 1 measure.

dimension = month

measure = sum(Total_time)/sum(Total_count)

how would I write this set analysis?

thank in advance

[Heny]

i want to ignore selection of month from filter

[VBD · Accepted solution]

Depend on your version :

 You can do sum({<Month=>}Total_time)/sum({<Month=>}Total_count)

Or

{<Month=>} sum(Total_time)/sum(Total_count)

Regards

[Heny · Accepted solution]

thank you so much

it works!