Forum Discussion
wrong column total for calculate measure
hi i have a measure calculate by this formula MixCalc:=iferror( ( ([Avg CY]-[Avg LY]) *( divide( [amountLY],(CALCULATE( [amountLY],allselected(), values(BYBRANDCOLLCHMKT[Brand]))) ) )),0) ...
of course
i send you by email the
entire file
thanks a lot
i attach the original excel which has the issue at onedrive link
you could download it at File Excel
the "mix market" and "delta sconto" have a wrong column sum (i'd like to have a simply sum, not a ricalculation at parent level)