topic Re: DAX - SKIPPING A FILTER in DAX Commands and Tips

DAX - SKIPPING A FILTER

Anonymous — Mon, 10 Jun 2024 08:25:08 GMT

Hello everybody,

I hope you are very well.

Is there any way to make that total in "WDT y MPH" (2.263) appear in each row where it now appears with different numbers? That would mean it should skip the filter in the table "LATE DELIVERY REASON" (in this case is "blank"). What I want is to divide each "WDT y MPH" occurrence by its total, to have the %.

Thanks a lot. Best regards,

Chema Ortega

Re: DAX - SKIPPING A FILTER

ValtteriN — Mon, 10 Jun 2024 08:25:44 GMT

Hi,

You can use ALL or REMOVEFILTERS in your calculate e.g. REMOVEFILTERS('YourTableName'[LATE DELIVERY REASON]) or ALL('YourTableName'[LATE DELIVERY REASON])

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: DAX - SKIPPING A FILTER

Anonymous — Mon, 10 Jun 2024 09:40:57 GMT

Thanks sooo much, ValtteriN! You solved the issue! I used

# total sin late = CALCULATE([# Rows],ALL('QUERY SQL ROCHA DESDE 2020'[LATE_DELIVERY_REASON])), and it worked as I wanted... Thanks a lot!

Chema Ortega