Forum Discussion
sirros_iot
Helper III
Helper IIIChoosing different variable
Hello all! *I can't use calculated column because I'm getting the data by Streaming Direct Query on PBI online.. I would like to choose the variable value, for example.. This is level fiter, ...
Hi sirros_iot,
You need to have a reference to a column or another table that allows you to do it.
Regards,
MFelix
MFelix
Super User
Super UserHi sirros_iot,
Not sure about the question you are making not really explicit and with very little data.
Regarding the last part of you question you can add variables in your DAX expression something like
CAR SPEED =
VAR InsertDistance = MAX(Table[Distance])
Var Inserttime = MAX(Table[Speed])
Return
CALCULATE (insertdistabce x inserttime)
Can you share sample.data.and expected.result for better help.
Regards
MFelix
Not sure about the question you are making not really explicit and with very little data.
Regarding the last part of you question you can add variables in your DAX expression something like
CAR SPEED =
VAR InsertDistance = MAX(Table[Distance])
Var Inserttime = MAX(Table[Speed])
Return
CALCULATE (insertdistabce x inserttime)
Can you share sample.data.and expected.result for better help.
Regards
MFelix
sirros_iotHelper III
Helper IIISorry about the mess ... I don't have PRO level to share you the report.. I will try to explain it better I have a visual table in my report, and there I have one column that is a measure. The measure has a variable, but I don't have value to that variable. I want to choose the variable value, is that possible? Is there a way of entering the data? Or selecting from 4 options could be a way. Thank you, Diego