Forum Discussion

VTB's avatar
VTB
Frequent Visitor
7 years ago

Inner Filter and Outer Filter not working

hi folks,    I am trying to do a dual filter on a table, running DirectQuery mode, which doesnt seem to work as I hoped - hoping someone here has better ideas.   Example table:   Outcome dat...
Filtering
Max date from select dates in Dataset
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

Hi VTB 

 

Try the below.

Measure = 
VAR _date = CALCULATE( MAX( 'Outcome Table'[Outcome date] ), ALL('Outcome Table' ) )
VAR _one = CALCULATE( MAX( 'Outcome Table'[Outcome 1] ), 'Outcome Table'[Outcome date] = _date )
RETURN CALCULATE( SUM( 'Outcome Table'[Outcome Show] ) * 1, 'Outcome Table'[Outcome 1] = _one )
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

  • VTB's avatar
    VTB
    Frequent Visitor
    7 years ago

    got the syntax to work, but returns blanks for every row.