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_iotSorry 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- sirros_iot
- MFelix
Hi sirros_iot,
I created a PBIX file with a sample data, I have created a table with the What If option on the modeling tab,
Then created a measure with a variable that is based on the table created in the previous step, that selects the lue on the slicer.
This is just a simple example but it how it works.
Regards,
MFelix
- sirros_iot
Thank you for the reply MFelix! That's what I would like to do!
But I think I can't create that parameter table.. I'm getting the data by Push Streaming Dataset
Do you know a way of doing that without creating any data?
Best Regards,
Diego