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.
Please help me, how do I assign "Not Assigned" to my blank values
Market Segment Blanks = IF(ISBLANK(SUMMARIZE(R_ESURVEY_CONSOLIDATED_V001,R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment])),"Not Assigned",SUMMARIZE(R_ESURVEY_CONSOLIDATED_V001,R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment]))
this other formula only returns 1 value
Market Segment Blanks = IF(ISBLANK(MAX(R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment])),"Not Assigned",MAX(R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment])
You'll need to add a calculated column.
Column = IF ( R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment] = BLANK (), "Not Assigned", R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment] )
it works on a calculated column, but I was thinking of putting it in a measure, is it possible?
If anyone has the answer for this still. My data set is too large to be adding calculated columns really need to do it in measure if anyone has a workaround?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |