Forum Discussion

Nattybb33's avatar
Nattybb33
New Member
3 years ago
Solved

Filtrer sur une variable multiple

Bonjour,  je suis en train de réaliser un rapport et je voudrais faire un filtre sur une variable qui peut avoir plusieurs réponses délimitées par "/". Par exemple la variable "Activité" à plusieur...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Nattybb33 ,

     

    According to your statement, I think you split [Activity] by "/" into column.

    Here I suggest you to split [Activity] by "/" into row.

    New Table:

    Then create a DimActivity table and create a relationship between it and fact table.

    DimActivity = 
VALUES('Table'[Activity])

    Measure:

    Combine = 
CONCATENATEX('Table',[Activity],"/")

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

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

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Nattybb33 ,

 

According to your statement, I think you split [Activity] by "/" into column.

Here I suggest you to split [Activity] by "/" into row.

New Table:

Then create a DimActivity table and create a relationship between it and fact table.

DimActivity = 
VALUES('Table'[Activity])

Measure:

Combine = 
CONCATENATEX('Table',[Activity],"/")

Result is as below.

 

Best Regards,
Rico Zhou

 

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

 

 

Nattybb33's avatar
Nattybb33
New Member
3 years ago

Bonjour, 

merci.