Forum Discussion

JonnyH's avatar
JonnyH
Frequent Visitor
9 years ago

SummarizeColumns() and AddMissingItems() may not be used in this context

Hi,   I'm still new to Power BI but I recently upgraded my version of Power BI and now one of my formulas is returning the following error.   The formula is ASQ = SUMMARIZECOLUMNS(Sprints[Qtr],FI...
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi JonnyH,

 

Based on my test, the SUMMARIZECOLUMNS function works fine in the new version of PowerBI (2.40.4554.421 64-bit (October 2016)). So, did you change anything in your report after upgrading? Were the datasource, table view and formula exactly the same as before? 

 

What is the error message? Please provide some sample data and all the relative formulas for further analysis so that I can reproduce your scenario.

 

Best regards,
Yuliana Gu

  • JonnyH's avatar
    JonnyH
    Frequent Visitor
    9 years ago

    Hi v-yulgu-msft,

     

    The error message is the same as in the subject line i.e. 'SummarizeColumns() and AddMissingItems() may not be used in this context' my version is Version: 2.40.4554.463 64-bit (October 2016), I don't believe I changed anything.

     

    Basically all I want to do is take a Date field in my Transaction table, and look that up in a sprint table which has a Quarters column, so basically I have a transaction table that has things like user stories in it 

     

    Transaction table has coluumns:

    SnapShotDate,    User Story No.,   Description, Story Points, etc, etc 

     

     

    And sprints table has columns

    Sprint Start Date,   Sprint End Date,  Qtr No 

     

    All I want to do is look up the snapshotdate from the transaction table and return which Sprint number and Quarter the user story was delivered (the Sprint Qtr can differ from Calendar Qtr)

     

     

     

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi JonnyH,

       

      I am still confused about your requirement that "look up the snapshotdate from the transaction table and return which Sprint number and Quarter the user story was delivered". If possible, would you please use some sample data, and provide an image to show your expect result?

       

      Thanks,
      Yuliana Gu

      • zibbyroman's avatar
        zibbyroman
        New Member
        9 years ago

        I am suffering from the same symptoms. The statement below stopped working after the January 2017 upgrade.

         

        Activity =
        GENERATE (
        FILTER ( SUMMARIZECOLUMNS ( 'Smartcards'[Smartcard ID] ), 'Smartcards'[Smartcard ID] <> BLANK () ) ,
        FILTER ( SUMMARIZECOLUMNS ( 'all trips'[Operations Date]), 'all trips'[Operations Date] <> BLANK () )
        )

         

        It now comes back with "SummarizeColumns() and AddMissingItems() may not be used in this context." I am certain that no changes were made to the code or even to the data.

         

        Please help.

        Zibby