Forum Discussion

SebaSpotti's avatar
SebaSpotti
Advocate II
2 years ago
Solved

Using a measure to define a CALCULATETABLE

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'[Ex...
  • selimovd's avatar
    2 years ago

    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