Forum Discussion

Kagechiyo's avatar
Kagechiyo
New Member
5 years ago

different DAX output between SSAS vs Import

hello,   i would like to make a accumlative / pareto chart by year-month, in clustered chart. i also make 2 reports : A - first i make using import data from DB source directly then B - i make ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Kagechiyo , Try a measure like

 

var currentmon =
maxx(allselected('VW_FactDetailUnit'),'VW_FactDetailUnit'[month])

var sumtabledax =
SUMMARIZE(
ALLSELECTED('VW_FactDetailUnit'),
'VW_PC_FactDetailVIN'[dDate],
"kumakun", SUM('VW_FactDetailUnit'[Qty]))

var cummulativesum =
SUMX(
FILTER(sumtabledax, MONTH('VW_FactDetailUnit'[dDate]) <= currentmon),
[kumakun]
)

return
cummulativesum