Forum Discussion

JaromBIDEVatDK's avatar
4 years ago
Solved

DAX ignore row context keep slicer context

Hi there,   I am to write a measure that just returns the 21.26 subTotal in the image below. I tried writing averagex(allselected(table), measure) but that is returning all rows in the table ignori...
  • JaromBIDEVatDK's avatar
    4 years ago

    Got it: 

    Average Days = Calculate(measure used for column, ALLSELECTED('table used for far left column'))