Forum Discussion
wrong column total for calculate measure
thanks a lot for your reply
i'm going to show you the detail of the table
this is the table
the delta_sconto_market measure work fine but it has wrong column total, let me show the measure
DELTA_Sconto_Market:=iferror(
(
([Avg Discc CY]-[Avg Discc PY])
*( divide( [GS CY],(CALCULATE( [GS CY],allselected(), values(BYBRANDCOLLCHMKT[BRANDCOLL]))) ) )),0)
the [Avg Discc CY] and [Avg Discc PY] are two measure calucalte at row level by measure lake this
Avg Discc CY:=(IFERROR([NS CY]/[GS CY]-1,0))
your solution seems work only when there is one row at [market] level (leaf level) (first case)
but in second case your formula not works
do i use a wrong method to get value at different row level i mean (CALCULATE( [GS CY],allselected(), values(BYBRANDCOLLCHMKT[BRANDCOLL]))))
or it is right ?
thanks a lot
Community ChampionHi Anonymous
Try replacing HASONEVALUE with ISFILTERED...
Measure =
IF (
ISFILTERED ( TABLE[brand] ),
[MixCalc],
SUMX ( ALL ( TABLE[brand], Table[Channel], Table[Market] ), [MixCalc] )
)seems that not work
your formula (traslated to the correct column name) is
test:=IF (
ISFILTERED ( BYBRANDCOLLCHMKT[BRANDCOLL] ),
[DELTA_Sconto_Market],
SUMX ( ALL ( BYBRANDCOLLCHMKT[BRANDCOLL], BYBRANDCOLLCHMKT[ACTUALCHANNEL], BYBRANDCOLLCHMKT[Market] ), [DELTA_Sconto_Market] )
)my source formula of measure
DELTA_Sconto_Market:=iferror(
(
([Avg Discc CY]-[Avg Discc PY])
*( divide( [GS CY],(CALCULATE( [GS CY],allselected(), values(BYBRANDCOLLCHMKT[BRANDCOLL]))) ) )),0)seems that works fine there are only one row at the leaf level
if you need other detail let me know
thanks a lot
for your help
- Zubair_Muhammad
Anonymous
Could you share your file???
of course
i send you by email the
entire filethanks a lot