Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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.
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.
Measure=DIVIDE(CALCULATE(SUM(Table[Pictures per camera]),ALLSELECTED(Table[Camera])), MAX(Table[Accidents per segmet]))
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |