Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
tony-G_2020
Frequent Visitor

Display custom row in DAX measure

‎12-06-2023 04:16 PM

Is there a way in Dax to hardcode id=6 to id=9 in a measure? 

 

IDCodeNo
1AAA12
2BBB23
3CCC22
4DDD33
5EEE44
6FFF50
7FFF50
8FFF50
9FFF50
Labels:
Message 1 of 3
369 Views
0
1 ACCEPTED SOLUTION
danextian
Super User
Super User

‎12-06-2023 07:33 PM

Hi @tony-G_2020 ,

 

You can write a simple formual conditional formula to for that that may not be what you want.

=
IF ( SELECTEDVALUE ( data[ID] ) = 6, 9, SELECTEDVALUE ( data[ID] ) )

But measures are affected by the columns you put in a visual. If you don't place the ID column, you won't get the correct result.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

Message 3 of 3
329 Views
0
2 REPLIES 2
danextian
Super User
Super User

‎12-06-2023 07:33 PM

Hi @tony-G_2020 ,

 

You can write a simple formual conditional formula to for that that may not be what you want.

=
IF ( SELECTEDVALUE ( data[ID] ) = 6, 9, SELECTEDVALUE ( data[ID] ) )

But measures are affected by the columns you put in a visual. If you don't place the ID column, you won't get the correct result.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Message 3 of 3
330 Views
0
Ashish_Mathur
Super User
Super User

‎12-06-2023 07:21 PM

Hi,

What is the end goal?  What do you want to achieve?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Message 2 of 3
331 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All