Forum Discussion

Murkow's avatar
Murkow
Frequent Visitor
8 years ago
Solved

Calculated column based on formula, filter and date - using slicer

Hello everybody, I'd like to ask you for help with a calculated column. I'll use the following table to demostrate it on an example     In order to get the Requested column I use this form...
Need Help
Tips and Tricks
Tutorial Requests
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Murkow,

     

    Please try below measure:

    requested =
CALCULATE (
    SUM ( Query1[Hours] ),
    ALLSELECTED ( Query1[Spent_on] ),
    ALLSELECTED ( Query1[Project category] ),
    Query1[project category] <> "_Attendance"
)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Murkow,

 

Please try below measure:

requested =
CALCULATE (
    SUM ( Query1[Hours] ),
    ALLSELECTED ( Query1[Spent_on] ),
    ALLSELECTED ( Query1[Project category] ),
    Query1[project category] <> "_Attendance"
)

 

Best regards,

Yuliana Gu

  • Murkow's avatar
    Murkow
    Frequent Visitor
    8 years ago

    Hi Yuliana,

    great help, thank you!