Using a measure to define a CALCULATETABLE

[SebaSpotti]

Hi, I'm creating a CALCULATETABLE  in this way:

CalcTable= CALCULATETABLE(Table,

Table[Name] in {"A","C","F},

Month(Table[Date])=Table[ExamMonth]))

But i get an error. Note that 'Table'[ExamMonth] is a measure, if I insert directly a number, such as 4, the CalcTable get generated.

Any suggestions?

Thanks!

[selimovd · Accepted solution]

Hey @SebaSpotti ,

you can try the following:

CalcTable =
VAR _ExamMonth = [ExamMonth]
RETURN
    CALCULATETABLE (
        Table,
        Table[Name] IN { "A", "C", "F" },
        MONTH ( Table[Date] ) = _ExamMonth
    )

I'm wondering, what exactly do you plan to do?
Do you want to use that in a measure or do you want to use that as a calculated table? Be aware if you are using a calculated table, that table is not dynamic. So after loading the file, the table won't change anymore.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[SebaSpotti]

@selimovd thank you!

I was simply trying to calculate some measure, but probably i need them to be update so i'm changing the calculations.