How to use multiple filters of the same column to compare data of value selected from both filters ?

[Anonymous]

Hello everyone,

I have the following tables.

"Filiales_2" is a duplicate of "Filiales", in which I have all the names of my different networks. "Absentéisme Maladie" is the table in which I have the data for each network, and "Filiales" and "Filiales_2" tables are linked to "Absentéisme Maladie" with a key column. "Calendrier" is a table generated with CALENDARAUTO(), linked to "Absentéisme Maladie" with a "date" column.

I'm trying to create a scatter chart on which I would be able to compare the data between one network selected in a filter of network names done with the "name" column of "Filiales", with one or multiples networks selected in another filter of network names from "name" column of "Filiales_2". 

For this, I created 2 different measures using HASONEVALUE(), to display the data if some networks were selected in both filters ("ACT_MAL" is the column that contains the data in the "Absentéisme Maladie" table):

Réalisé MAL MaFiliale = IF(HASONEVALUE(Filiales[Nom de la filiale]), AVERAGE('Absentéisme Maladie'[ACT_MAL]))

and 

Réalisé MAL AaComparer = IF(HASONEVALUE(Filiales_2[Nom de la filiale]), AVERAGE('Absentéisme Maladie'[ACT_MAL]))

The idea was to put those two measures on the X-axis, a calculated measure which calculates the variation of this data on the Y-axis, and the "Date" column of the "Calendrier" table as play axis.

My problem here is that when I'm putting the two measures on the X-axis, I'm getting the following error : 

Error Message:
The field values ​​on your X axis do not match. Choose 'Don't totalize' for all X-axis fields or remove all but one field.

I don't know why it says that the values do not match because it's the same data that is calculated and I don't see any option saying "Don't totalize", so I'm not sure to understand how to solve my problem...

If anyone has an idea how to solve this, it would be nice! 🙌

Thanks in advance!

Best regards,

[amitchandak]

@Anonymous , Are you looking for something like this

Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: https://youtu.be/exN4nTewgbc

[Anonymous]

@amitchandak Hello, thanks for your reply!

That's something like that I'm looking for, thanks. However, I have the impression that it is only possible to compare the data using a table and not with a scatter plot. I still get the same error: "The field values ​​on your X-axis do not match. Choose 'Don't totalize' for all X-axis fields or remove all but one field."

Best regards, 

Eric