Forum Discussion

PBIUser1316's avatar
PBIUser1316
Frequent Visitor
6 years ago
Solved

Filtering down to one record with DAX

Hello,   I'm trying to get one value in a measure and to do this I need to filter a table by four different columns. I can't use a calculated column for this because it takes too much calculation ...
Need Help
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    PBIUser1316 ,

     

    You may also modify the measure like below:

    gl =
CALCULATE (
    LASTDATE ( 'Facts'[PeriodID] );
    FILTER (
        'Facts';
        'Facts'[column1] = "value1"
            && 'Facts'[column2] = "valuex"
            && 'Facts'[column3] = "valuey"
    )
)

    If you still have other issues, please share some sample data and give the expected result.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

PBIUser1316 ,

 

You may also modify the measure like below:

gl =
CALCULATE (
    LASTDATE ( 'Facts'[PeriodID] );
    FILTER (
        'Facts';
        'Facts'[column1] = "value1"
            && 'Facts'[column2] = "valuex"
            && 'Facts'[column3] = "valuey"
    )
)

If you still have other issues, please share some sample data and give the expected result.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PBIUser1316's avatar
PBIUser1316
Frequent Visitor
6 years ago

v-yuta-msft 

Thanks that really helped me to apply multiple filters with the "&&".

 

One last problem that I have is, that I need one measure not to be affected by a slicer.

I tried the all-Function like this:

glistunfilterable = all('Dax Measures'; [glist])
=> error: "the ALL function expects a table reference expression for argument '2', but a string or numeric expression was used."
And like this:
glistunfilterable = all('Dax Measures'; 'Dax Measures'[glist])
With the same error message.
 
So it looks like I can't use the all-function with a measure.
Can I use the all-function with a filter-function somehow?