Forum Discussion

Julia997's avatar
Julia997
Frequent Visitor
3 years ago

ABC statics filter

I have try to create ABC analysis, I have done the first cumulated but after that I found difficult.   My dataset is like this https://1drv.ms/x/s!AvMy-Bzzx3mqgwmKSZm6wr_W4VXr?e=Jwwbji&nav=MTVfezAw...
"DAX"
"Need Help"
Dax Help
MasterSonic's avatar
MasterSonic
Helper IV
3 years ago

this perhaps

RANK = RANKX(FILTER(ALL('TABLE'), YEAR('TABLE'[DATE]) = SELECTEDVALUE(YEAR('TABLE'[DATE]))),[FATT],,DESC,Dense)

 

M_Running total = SUMX( FILTER( SUMMARIZE( 'TABLE', 'TABLE'[NAME], "Year", YEAR('TABLE'[DATE]) ), (YEAR('TABLE'[DATE]) = SELECTEDVALUE(YEAR('TABLE'[DATE]))) && (RANKX(FILTER(ALL('TABLE'), YEAR('TABLE'[DATE]) = SELECTEDVALUE(YEAR('TABLE'[DATE]))),[FATT],,DESC,Dense) <= [RANK]) ), SUM('TABLE'[FATT]) )

  • Julia997's avatar
    Julia997
    Frequent Visitor
    3 years ago

    My year in this case is a text, not a date. How can I do? The second DAX doesn't work