DAX query without specific filter?

[h4tt3n]

Hello,

I have a data table containing among other a timestamp, a numerical data value, and a data type:

The data is displayed in a report:

In the "Calibration" drop down menu you can see the three present datatypes. Notice the black curve over the red/green bar graph. This is data of datatype temperature, which is shown using the following DAX measure:

Supply temperature = calculate( selectedvalue( 'Data'[value] ), 'Data'[unittypeinputid] = 1511 )

What I would like to do is to always show the temperature curve no matter what datatypes are selected i the "Calibration" menu. 

I know there are ways to control filter context using  the filter pane and DAX filter functions, but after several hours of researching and experimenting I haven't been able to crack this nut. Any help is appreciated.

Thanks in advance, Mike

[Anonymous · Accepted solution]

Supply temperature = 
    calculate( 
        selectedvalue( 'Data'[value] ),
        'Data'[unittypeinputid] = 1511,
        ALL( 'Data'[datatype] )
    )

[h4tt3n]

It works exactly as it should! @Anonymous Thanks for helping me out on this. Now comes the harder part, figuring out *how* it works...

[Anonymous]

If you read the book "The Definitive Guide to DAX" by Marco Russo and Alberto Ferrari, you'll know everything about how DAX works.

[h4tt3n]

I have the book, I am just not through all of its 740 pages yet 🙂 Again, thanks for your help and time.

[Anonymous]

Just read the chapter on CALCULATE and you'll know almost everything.... at least about how this function works with filters. This is all you need in order to understand the above piece of code.

[Anonymous]

or:

Supply temperature = 
    calculate( 
        selectedvalue( 'Data'[value] ),
        'Data'[datatype] = "temperature"
    )