Howdy there,
I spent most of my afternoon trying to resolve this problem. I read a lot on the Internet, but much didn't make sense to me.
Let me expose you my problem. I have data that look like this :

I defined clusters in two formats (because I don't know which format to use !). The trick : a car can belong in several clusters.

I'd like to aggregate my COI according to those clusters. For that, I want to use a slicer :

If I click on a cluster, I want my pivot table to aggregate the COI for all the cars which respect this condition.
My data model looks like this right now :

I cannot connect Filters[Car] to Data[Car] because values in Filters[Car] are non-unique. I could do it with 'Filters - Possibility 2' though (see the different format above), but then I can't link it to my clusters (since there are several columns).
So how to pass my cluster ('Slicer field') to my data ? Is there a way to do this usingPowerPivot, without adding one column for each cluster at the end of my data, like I'd do with Excel ?
Could you also inform if this 'notion'/problem got a name, so I can search on Google more efficiently ?
Thank you very much !
Have a nice day.
I spent most of my afternoon trying to resolve this problem. I read a lot on the Internet, but much didn't make sense to me.
Let me expose you my problem. I have data that look like this :

I defined clusters in two formats (because I don't know which format to use !). The trick : a car can belong in several clusters.

I'd like to aggregate my COI according to those clusters. For that, I want to use a slicer :

If I click on a cluster, I want my pivot table to aggregate the COI for all the cars which respect this condition.
My data model looks like this right now :

I cannot connect Filters[Car] to Data[Car] because values in Filters[Car] are non-unique. I could do it with 'Filters - Possibility 2' though (see the different format above), but then I can't link it to my clusters (since there are several columns).
So how to pass my cluster ('Slicer field') to my data ? Is there a way to do this usingPowerPivot, without adding one column for each cluster at the end of my data, like I'd do with Excel ?
Could you also inform if this 'notion'/problem got a name, so I can search on Google more efficiently ?
Thank you very much !
Have a nice day.