Dividing a row by the total of another column

[Chema_Ortega_Ga]

Hello,

I hope everyone is good.

I have:

Hello everyone. I hope you all are great!. 

The column  # Rows = COUNTROWS('QUERY SQL ROCHA DESDE 2020')

The column  # total sin late = CALCULATE([# Rows],ALL('QUERY SQL ROCHA DESDE 2020'[LATE_DELIVERY_REASON]))

Now I need to calculate each row of "# Rows" by the total of "# total sin late" (23.928). Anyone who knows how to do it? 

Thanks a lot. Best regards!

Chema ortega

[Anonymous · Accepted solution]

Hi @Chema_Ortega_Ga 

Please try  the following DAX:

column = 
Var _sum_sin_late = SUM('Table'[# total sin late])
RETURN 
DIVIDE([# Rows],_sum_sin_late)

Result:

Best Regards,

Jayleny

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

[Chema_Ortega_Ga]

Ok, thanks a lot, Jialongy!!!

I'll try it. Best regards,

Chema Ortega

[ArtisanAmbrosia]

There may be context missing with a simple solution like this, but have you tried something like:

Rows by Total =
VAR Rows = COUNTROWS('QUERY SQL ROCHA DESDE 2020')

VAR totalsinlate = CALCULATE([# Rows],ALL('QUERY SQL ROCHA DESDE 2020'[LATE_DELIVERY_REASON]))

RETURN

DIVIDE(Rows, totalsinlate)

[Chema_Ortega_Ga]

Ok, thanks a lot, artisan!!!

I'll try it. Best regards,

Chema Ortega