Forum Discussion

purple_SP's avatar
purple_SP
Helper I
1 year ago
Solved

Issue with Summarizing Table

Hi all, I'm trying to create an aggregated version of a fact table and am running into some issues with the summarization.   My Fact table is in this format:   query_id month source product...
  • dharmendars007's avatar
    dharmendars007
    1 year ago

    Hello purple_SP , 

     

    Please try adding the "All" or "AllSelected" function within your summarized formula so that you can ignore specific filters if there is any..

     

    SUMMARIZECOLUMNS(
    FACT_TABLE[month],
    FACT_TABLE[source],
    FACT_TABLE[product],
    FACT_TABLE[location],
    FACT_TABLE[category],
    FACT_TABLE[indicator],"total_queries", DISTINCTCOUNT(ALL(FACT_TABLE[query_id])))

     

    If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

     

    Thank You

    Dharmendar S

    LinkedIN 

dharmendars007's avatar
dharmendars007
Memorable Member
1 year ago

Hello purple_SP , 

 

Please try adding the "All" or "AllSelected" function within your summarized formula so that you can ignore specific filters if there is any..

 

SUMMARIZECOLUMNS(
FACT_TABLE[month],
FACT_TABLE[source],
FACT_TABLE[product],
FACT_TABLE[location],
FACT_TABLE[category],
FACT_TABLE[indicator],"total_queries", DISTINCTCOUNT(ALL(FACT_TABLE[query_id])))

 

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

 

Thank You

Dharmendar S

LinkedIN