Choosing different variable

[sirros_iot]

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, and is selected "is = 2", sorry about the portuguese...

Measure A = //I don't know how to do it

Measure B = 
          IF{ table [Measure A] = 1; This does something;
                   IF{ table [Measure A] = 2; This does otherthing( Would select this if Measure A was working, as you can see at the image above); 
                             IF{ table [Measure A] = 3; This is the command that I want to select via level filter;
                                        IF{ table [Measure A] = 4; As this one...; 
}

This is just a way I think can solve my problem, I want to select different functions into one measure( Measure B). And I want to insert Measure B in one visual table. Doesn't exist a way of inserting data into the report, right, like...
CALCULATING CAR SPEED
Insert distance:_______
Insert time:_______
                                CALCULATE

Thank you all,
Best Regards,

Diego

[MFelix]

Hi @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

[sirros_iot]

Hello @MFelix, do you if it is possible?

Thanks,

Diego

[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 · Accepted solution]

Hi @sirros_iot,

You need to have a reference to a column or another table that allows you to do it.

Regards,

MFelix

[sirros_iot]

Sorry 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