Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
LamSar
Helper III
Helper III

Summarizecolumns and AddMissingItems cannot be used in this context

Good afternoon,
I have this measure:
_Effectief Aantal Dagen met FiliaalAfsluit:=
Var berekening = CALCULATE(COUNTROWS(SUMMARIZECOLUMNS(FiliaalAfsluit[SK_Datum], FiliaalAfsluit[SK_Partij])), FILTER(Partij, Partij[Keten] in {"CR", "DH"}))
return
berekening

This measure works fine in Power BI desktop. But when I add it to the tabular model I get this error:
Summarizecolumns and AddMissingItems cannot be used in this context

 

Any ideas on how I need to change this measure? 

 

Thank you. 

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

You can't use SUMMARIZECOLUMNS in a measure, try using SUMMARIZE instead

_Effectief Aantal Dagen met FiliaalAfsluit :=
VAR berekening =
    CALCULATE (
        COUNTROWS (
            SUMMARIZE (
                FiliaalAfsluit,
                FiliaalAfsluit[SK_Datum],
                FiliaalAfsluit[SK_Partij]
            )
        ),
        FILTER ( Partij, Partij[Keten] IN { "CR", "DH" } )
    )
RETURN
    berekening

View solution in original post

1 REPLY 1
johnt75
Super User
Super User

You can't use SUMMARIZECOLUMNS in a measure, try using SUMMARIZE instead

_Effectief Aantal Dagen met FiliaalAfsluit :=
VAR berekening =
    CALCULATE (
        COUNTROWS (
            SUMMARIZE (
                FiliaalAfsluit,
                FiliaalAfsluit[SK_Datum],
                FiliaalAfsluit[SK_Partij]
            )
        ),
        FILTER ( Partij, Partij[Keten] IN { "CR", "DH" } )
    )
RETURN
    berekening

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.