topic Re: Dividing a row by the total of another column in DAX Commands and Tips

Dividing a row by the total of another column

Anonymous — Mon, 10 Jun 2024 13:03:57 GMT

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

ArtisanAmbrosia — Mon, 10 Jun 2024 18:42:31 GMT

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)

Anonymous — Tue, 11 Jun 2024 07:04:07 GMT

Hi Anonymous

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.

Anonymous — Mon, 17 Jun 2024 10:08:00 GMT

Ok, thanks a lot, Jialongy!!!

I'll try it. Best regards,

Chema Ortega

Anonymous — Mon, 17 Jun 2024 10:08:26 GMT

Ok, thanks a lot, artisan!!!

I'll try it. Best regards,

Chema Ortega