topic Summarize DAX help in DAX Commands and Tips

Summarize DAX help

Cevola — Thu, 16 Mar 2023 18:24:52 GMT

Hello

I have the following visual

Measure=Pictures per camera / Accidents per segmet. How do i write the measure to summarize the data based on Segment.

I am expecting the result as

Segment Camera Pictures per Camera Accidents per segment Measure

A1_14b 7631 4302 4 1075.50

A1_17 1019 6969 9 1163.11

1020 3499

A10/I_01 9024 14993 12 1249.42

Please help me how to write the measure to summarize based on Segment.

Thanks in advance.

Re: Summarize DAX help

wdx223_Daniel — Fri, 17 Mar 2023 01:29:12 GMT

Measure=DIVIDE(CALCULATE(SUM(Table[Pictures per camera]),ALLSELECTED(Table[Camera])), MAX(Table[Accidents per segmet]))

Re: Summarize DAX help

v-zhangti — Mon, 20 Mar 2023 02:20:37 GMT

Hi, Cevola

You can try the following methods.

Measure = Var _N1=CALCULATE(SUM('Table'[Pictures per Camera]),ALLEXCEPT('Table','Table'[Segment])) Var _N2=CALCULATE(MAX('Table'[Accidents per segment]),ALLEXCEPT('Table','Table'[Camera])) Return DIVIDE(_N1,_N2)

Or:

Measure 2 = Var _table=SUMMARIZE(ALL('Table'),'Table'[Segment],'Table'[Accidents per segment],"DIVIDE",SUM('Table'[Pictures per Camera])/MAX([Accidents per segment])) Var _Divide=SUMX(FILTER(_table,[Segment]=MAX('Table'[Segment])),[DIVIDE]) Return _Divide

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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