DAX - SKIPPING A FILTER

[Chema_Ortega_Ga]

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

[ValtteriN · Accepted solution]

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/

[Chema_Ortega_Ga]

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