topic Filter function with DAX in DAX Commands and Tips

Filter function with DAX

Anonymous — Mon, 02 Jan 2023 13:59:19 GMT

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,

Re: Filter function with DAX

Greg_Deckler — Mon, 02 Jan 2023 14:10:10 GMT

Anonymous Try:

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

Re: Filter function with DAX

Anonymous — Tue, 03 Jan 2023 04:49:49 GMT

Hi Anonymous ,

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

Re: Filter function with DAX

Anonymous — Tue, 03 Jan 2023 09:33:32 GMT

Anonymous Greg_Deckler

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

Have a nice day