Forum Discussion
Helper IIIChoosing different variable
Hi sirros_iot,
You need to have a reference to a column or another table that allows you to do it.
Regards,
MFelix
Super UserNot 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
Helper III- 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- MFelix
Hi sirros_iot,
You need to have a reference to a column or another table that allows you to do it.
Regards,
MFelix