SUMMARIZECOLUMNS with query context related to date dimention table

[Parthsh93]

Hi all

I am trying to create a table using

SUMMARIZECOLUMNS function

the problem is when I am putting them in visuals, I am not able to use visual filters (query context) from my existing date dimention table

or fact table.

table shipments = 

SUMMARIZECOLUMNS(
    
    
        dDate[Year],
        dDate[Month],
            "shipments Saved", 
           [Shipments Saved_corrected TEST])

 

I need to know if I can do this, if yes than how.
And should I be using SUMMARIZE function instead of

SUMMARIZECOLUMNS?
Any suggestions are welcomed
TIA

[v-gizhi-msft · Accepted solution]

Hi,

It works well here:

Please check the filter field [Year] comes from new summarize table but not from original table.

If choosing [Year] from original table to filter, it caused the same issue as you like below:

If you still want to use this [Year] from original table to filter the new summarize table visual, you can create a relationship between them.

See my attached pbix file.

Best Regards,

Giotto

[Parthsh93]

I am not able to view your file, it is asking for a Power BI update, but its up to date

[v-gizhi-msft]

Hi,

You can ignore this popup info and open the file normally.

Attached again.

Best Regards,

Giotto