Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Help - Filter Table with Multiple selection options

Community, I am seeking help with filtering a table by looking at the values across a few columns. Below is the table I am working with.   I am trying to filter the table with a Measure such...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

    You can use like this in filter

    filter(Table, (Table[Pass.Yaw]=100 && Table[Atd.Yaw] = Table[Data.Yaw] ) || (Table[Pass.Splitter]=100 && Table[Atd.Splitter] =Table[Data.Splitter] ))

    Like

    Measure = calculate(sum(table[value]),filter(Table, (Table[Pass.Yaw]=100 && Table[Atd.Yaw] = Table[Data.Yaw] ) || (Table[Pass.Splitter]=100 && Table[Atd.Splitter] =Table[Data.Splitter] )))

  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    Try to edit your "CL3" measure like the following DAX:

    CL3 =
AVERAGEX (
    ALL ( TestData ),
    TestData[SlopeCLxx^2] * TestData[Data.V^2] + TestData[SlopeCLxx] * TestData[Data.V] + TestData[Slope.CLIncpt]
)

    Or you could create a new measure:

    Measure =
AVERAGEX (
    ALL ( TestData ),
    [CL3]
)

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

Try to edit your "CL3" measure like the following DAX:

CL3 =
AVERAGEX (
    ALL ( TestData ),
    TestData[SlopeCLxx^2] * TestData[Data.V^2] + TestData[SlopeCLxx] * TestData[Data.V] + TestData[Slope.CLIncpt]
)

Or you could create a new measure:

Measure =
AVERAGEX (
    ALL ( TestData ),
    [CL3]
)