please suggest dax for Select Type from Table_Name where id=1 ?

[theaskk_1]

Hello Team,

     can i get some dax for below SQL statement and let me know please.

Select "Type" From Table_Name where Id=1,

I dont want to create other table like summarize or calculate table by using some measure is it possible?

[theaskk_1]

@Jayee ,
  i will telly you my requirement here .

When i select one value from slicer it should show that Name in KPI Card but when i select more than one value from slicer it suppose to show particular Name in KPI Card.

Suppose:-

values in slicer A,B,C,D.
1.when i select single value from above A,B,C,D shows respective value Card.
2.When i multi select like A and C then it show A in Card.

can you give any idea please.

[Jayee]

@theaskk_1 ,

suppose "letters" is the field name for the values A,B,C,D.

when you are using this Letters field in the slice then create a measure like

MinLetter = min(letters)

then use the filed in Card visual. it will give you the expected result

[Jayee · Accepted solution]

Hi @theaskk_1 ,

Measure will give only a single value if it solves your requirement try below one

Measure = calculate(max(Type),id=1)

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!