Tableau to DAX

[Anonymous]

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

[v-yalanwu-msft · Accepted solution]

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.

[amitchandak]

@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)