Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Tableau to DAX

Hi All,

 

I have this formula in Tableau

MC1M={FIXED [Oy Om],[SEQ]: IF SUM(IF [M C Survival Month Diff]<1 THEN 1 ELSE 0 END )>=1 THEN 1 ELSE 0 END}

OyOm=yearmonth

SEQ=1 to 60.

I wore the above in DAX as follows:

IF( CALCULATE(If(sum(Table1.[M C Survival Month Diff])<1,1,0),ALLEXCEPT(Table1,Table1[SEQ],Table[OY_OM]))>=1,1,0)
where
MC Survival Diff :
DATEDIFF((Table1[Date]),CALCULATE(MAX(Table1[Date]),ALLEXCEPT(Table1,Table1[SEQ])),MONTH)
Anything wrong with my DAX?
My calculation are not correct.
Regards,
Raj
 
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi， Anonymous ；

    You could create a measure as follows:

    Measure = IF( CALCULATE( COUNT('Table'[diff]),FILTER(ALL('Table'),[SEQ]=MAX([SEQ])&&[Oy Om]=MAX([Oy Om])&&[diff]=0))>=1,1,0)

    Or

    Measure 2 = IF(SUM([diff])<1,1,0)

    The final output is shown below:

    If I misunderstand your logic, can you share the results you want to output and your logic according to the simple sample ? because I am not particularly familiar with Tabulea.Looking forward to your reply!


    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , MC survival is measure then you do need a sum

     

    a new measure like

    If(sum(Table1.[M C Survival Month Diff]),ALLEXCEPT(Table1,Table1[SEQ],Table[OY_OM])<1,1,0)

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi， Anonymous ；

    You could create a measure as follows:

    Measure = IF( CALCULATE( COUNT('Table'[diff]),FILTER(ALL('Table'),[SEQ]=MAX([SEQ])&&[Oy Om]=MAX([Oy Om])&&[diff]=0))>=1,1,0)

    Or

    Measure 2 = IF(SUM([diff])<1,1,0)

    The final output is shown below:

    If I misunderstand your logic, can you share the results you want to output and your logic according to the simple sample ? because I am not particularly familiar with Tabulea.Looking forward to your reply!


    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.