Forum Discussion

h4tt3n's avatar
h4tt3n
Icon for Helper V rankHelper V
5 years ago
Solved

DAX query without specific filter?

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...
  • Anonymous's avatar
    Anonymous
    5 years ago
    Supply temperature = 
    calculate( 
        selectedvalue( 'Data'[value] ),
        'Data'[unittypeinputid] = 1511,
        ALL( 'Data'[datatype] )
    )
Anonymous's avatar
Anonymous
Not applicable
5 years ago
Supply temperature = 
    calculate( 
        selectedvalue( 'Data'[value] ),
        'Data'[unittypeinputid] = 1511,
        ALL( 'Data'[datatype] )
    )
h4tt3n's avatar
h4tt3n
Icon for Helper V rankHelper V
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago
    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's avatar
      h4tt3n
      Icon for Helper V rankHelper V
      5 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago
        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.