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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
SriGaG1
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? 

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

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

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors
Top Kudoed Authors