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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Parthsh93
Helper IV
Helper IV

SUMMARIZECOLUMNS with query context related to date dimention table

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])

 

 22.PNG24.PNG

 
 

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

1 ACCEPTED SOLUTION
v-gizhi-msft
Community Support
Community Support

Hi,

 

It works well here:

2.PNG

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:

3.PNG

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

View solution in original post

3 REPLIES 3
v-gizhi-msft
Community Support
Community Support

Hi,

 

It works well here:

2.PNG

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:

3.PNG

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

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

Hi,

 

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

Attached again.

 

Best Regards,

Giotto

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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