Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

LOD calculation in DAX

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!

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @Anonymous 

 

Can you please provide some dummy data to explain the expected result you want to have? I don't have experience in Tableau so some sample data and expected output would help me understand it better. And do you want to add a new column in an existing table? 

 

Best Regards,
Community Support Team _ Jing

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.