divide to other Colum total

160475 — Thu, 03 Nov 2022 11:09:46 GMT

dears,

good day!!

in the table below 2 columns total tickets and measure and i want to devide each row in total tickets to the Total for measure as showing below :

Re: divide to other Colum total

v-yadongf-msft — Fri, 04 Nov 2022 06:31:46 GMT

Hi 160475 ,

Please try ALL( ) function. For example,

This is my test table:

The measures I created:

Measure 1 = SUM('Table'[Value]) Measure 2 = SUMX(ALL('Table'),'Table'[Value]) Total ticket / Measure 2 = DIVIDE(SUM('Table'[Total tickets]),[Measure 2])

Then you can devide each row in total tickets to the Total for measure:

Best regards,

Yadong Fang

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

topic divide to other Colum total in DAX Commands and Tips

divide to other Colum total

Re: divide to other Colum total