Display custom row in DAX measure

[tony-G_2020]

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

ID	Code	No
1	AAA	12
2	BBB	23
3	CCC	22
4	DDD	33
5	EEE	44
6	FFF	50
7	FFF	50
8	FFF	50
9	FFF	50

[danextian · Accepted solution]

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.

[Ashish_Mathur]

Hi,

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