Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Incorrect grand total and performance issue

First I use the following measure   3 M avg Switch = var cost = SUM ( DimCost[Actual Price] ) *[3 M avg RD QTY] RETURN IF ( [Selected view] = 1, [3 M avg RD QTY], ROUND (cost, 0 ) ) ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

what are calculation for [Selected view], [3 M avg RD QTY]

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak 
I already mentioned 3 M avg RD QTY, which is

3 M avg RD QTY = 
CALCULATE (
    AVERAGEX ( VALUES ( DimDate[Month] ), [Total RD QTY]),
    DATESINPERIOD (
        DimDate[Date],
        EOMONTH(TODAY(),-1),
        -3,
        MONTH
    )
)

 

Selected view = SELECTEDVALUE('Stock View'[Code],1)