Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

LOD conversion to DAX

Hi, I need to Convert the Tableau exp into DAX {EXCLUDE [SEQ],[Floor[SEQ]/12]:                     CASE [Policy or Risk Survival:]                         WHEN 'XXX' THEN SUM(IF [SEQ]=0 THEN [M C...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago
    Converted it DAX
     
    CALCULATE(SUMX(wip_pj_py_experience,wip_pj_py_experience[M_Count_Policy]),(wip_pj_py_experience[SEQ]=0),
    ALLSELECTED(wip_pj_py_experience[SEQ],wip_pj_py_experience[DC_SEQ_GROUP]))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Any Help on this?