Filter function with DAX

[LD1]

Hi everyone, 

I would like to put a filter in a formula but i didn't find the solution on the web.

Can you help me to solve it please ? 

Here this is my explication :

1. I have 3 data in a table in the table "Marque"

Vetement

Chaussures

Accessoires

2. I would like to create one formula for each data of the table "Marque":

            => Sum of "Turnover€ "for [Marque="Vetement"]

            => Sum of "Turnover€" for [Marque="Chaussures"]

            => Sum of "Turnover€" for [Marque="Accessoires"]

Why? Because when i create a Visual, i have a couple of formula by "client" but i don't want to multiplicate all values with the data "Marque" only the Turnover. 

I haven't an other solution, if you have an optimisation of it, i'll take it 😉

Thank you in advance,

[Greg_Deckler · Accepted solution]

@LD1 Try:

Measure = SUMX(FILTER('Marque',[Column] = "Vetement"),[Value])

[LD1]

@v-yiruan-msft @Greg_Deckler 

It's amazing and finally so easy... ! Thank you for your help and your solution. 

Have a nice day

[v-yiruan-msft · Accepted solution]

Hi @LD1 ,

You can follow the below methods to get it, please find the details in the attachment.

1. Create a slicer using the field [Marque]

2. Create measures as below to get it

Sum of Turnover for Vetement = CALCULATE(SUM('Table'[Turnover€]),'Table'[Marque]="Vetement")

Sum of Turnover for Chaussures = CALCULATE(SUM('Table'[Turnover€]),'Table'[Marque]="Chaussures")

Sum of Turnover for Accessoires = CALCULATE(SUM('Table'[Turnover€]),'Table'[Marque]="Accessoires")

If the above one can't help you get the expected result, please provide some raw data in your table (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[Greg_Deckler · Accepted solution]

@LD1 Try:

Measure = SUMX(FILTER('Marque',[Column] = "Vetement"),[Value])