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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II
Helper II

Dow to derive a column based on a measure?

Hello Experts,


I am having a request to take out a column of the value is exceeding a particular amount. So these are the condiions


1). if the value is >5 and if it is satisfied, then we need to take out the subproduct. This need to be a column. (ex- if (value>5,sub_product). how to write this in power bi dax?

2)Can we use this column to join data sources? 


As long as it is a calculated column you will not have problems, remember that these are calculated only once until the next update of the report.

@Syndicate_Admin  Thank you. How to write that dax function? If i write the aove, everything will get blank. What I wrote is , If ( value>5, subcat,blank())


is this correct?

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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