LOD calculation in DAX

[Anonymous]

Hi, Please help me to convert the following Tableau calculation in DAX.

IF { FIXED [Student Id]:SUM(IF CONTAINS([XYZ],'FGEN') THEN 1 ELSE 0 END)} > 0 THEN 'First Gen' ELSE 'Non-First Gen' END

Thank you!

[amitchandak · Accepted solution]

@Anonymous , Try like

CALCUALTE( sumx(Values(Table[Student Id]), CALCUALTE( if( sumx(Table, if(containsstring([XYZ],"FGEN"),1,0) )>0, "First Gen","Non-First Gen" )))
allexcept(Table, Table[Student Id]))

refer LOD- FIXED (Level of Details): https://youtu.be/hU-cVOwDCvY

Tableau Vs Power BI: https://www.youtube.com/watch?v=tAmg00Wf_cw&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54