Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Helper V
5 years ago
Solved

Error with SelectedValue

Hi,


I have a measure below, which is working fine, except for the last filter condition. The filter attempts to find Month(date) and compare it with the selected month. However, this procudes the error "A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.". What is wrong and how to fix this?

Measure =
CALCULATE(SUM(Table1'[Net Value]),
'Table2'[Column1]=blank(),
'Table2'[Column2] = TRUE,
'Table3'[Column2] = "Invoiced",
MONTH('Table3'[Column1]) = [SelectedValue])


Need Help
  • nvprasad's avatar
    nvprasad
    5 years ago

    HI,

     

    You need to use Filter function after the SUM(Table1'[Net Value]).

     

    Appreciate a Kudos! 🙂
    If this helps and resolves the issue, please mark it as a Solution! 🙂

    Regards,
    N V Durga Prasad

     

1 Reply

  • nvprasad's avatar
    nvprasad
    Solution Sage
    5 years ago

    HI,

     

    You need to use Filter function after the SUM(Table1'[Net Value]).

     

    Appreciate a Kudos! 🙂
    If this helps and resolves the issue, please mark it as a Solution! 🙂

    Regards,
    N V Durga Prasad