Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello - I need your help to create a measure to find the text in the table and return a value based on the condition.
Condition - If "Table Exchange" has a value True return a value “Discounted” else Blank (No Value)
Thanks
Gaurav
| Exchange |
| FALSE |
| TRUE |
| FALSE |
| FALSE |
| FALSE |
| FALSE |
| TRUE |
| TRUE |
| TRUE |
| TRUE |
| FALSE |
| FALSE |
| FALSE |
| TRUE |
Solved! Go to Solution.
@gauravnarchal
For a measure:
Measure 1 = IF( SELECTEDVALUE(Table[Offer is Selected]), "Discounted" )
If you need a column then,
Column 1 = IF( Table[Offer is Selected], "Discounted" )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Column = if('Table 1 (3)'[Exchange]=TRUE(),"Discounted",BLANK())
@gauravnarchal
For a measure:
Measure 1 = IF( SELECTEDVALUE(Table[Offer is Selected]), "Discounted" )
If you need a column then,
Column 1 = IF( Table[Offer is Selected], "Discounted" )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 98 | |
| 72 | |
| 50 | |
| 50 | |
| 43 |