Summarizing a table from direct query connection in a mixed storage mode pbix

[tpathy]

I have a pbix report that uses mixed storage. The direct query data that I am connecting in this report comes from a different power bi report hosted in power bi services. Ultimately, my goal is to create a combined table from my import method data with the direct query data. To do that, I would like to first summarize direct query data into an import table.

Below is a sample of the dax that I have:  

SUMMARIZECOLUMNS('Mapped Cost ALL'[Portfolio], 
    'Mapped Cost ALL'[Service], Dates[Fiscal Period],Dates[Fiscal Year],
    FILTER('Mapped Cost ALL', 'Mapped Cost ALL'[Tier] = "Portfolio Name"),
    "2021 FY", [measure1], "2022 YTD", [meausre2], 
    "2022 GFO", [measure3], "2022 LE", [measure4])

When running this in the formula bar, the following error arises:

This error would continue on to all the measures that are placed in the table. 

However, this dax works when running it in dax studio. I can see the output coming out as how I would like it to. 

Any ideas how to go about the problem?

[v-yanjiang-msft]

Hi @tpathy ,

What version is your Power BI Desktop? This seems a issue of Oct version, but fixed in the Nov. version. Please try to update to the latest version.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tpathy]

I am on the October 2022 version but, this is the matches the version that you have linked 2.110.1161.0. Upon installing the version you have linked, it is still listed as October 2022 version.

[v-yanjiang-msft · Accepted solution]

Hi @tpathy ,

I'm sorry I made a mistake, the Nov version has not been released yet. We have reported the issue and submitted it to the internal ICM platform, No:344820703.

The fix will deployed in the Nov. version Desktop.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.