Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Groupby/Summarize and sum calculated Column

I have a table similar to this, I have a bar chart which contains only Name and Total Cost. If i filter value Greater than 3500 then the bar chart should show Customer 1 = 7000 but it picksup single...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try to create this calculated table:

    Table 2 = SUMMARIZE('Table','Table'[Name],"Total Cost",SUMX(DISTINCT('Table'),'Table'[No. Unit]*'Table'[Per Unit]))

    The result shows:

     

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try to create this calculated table:

Table 2 = SUMMARIZE('Table','Table'[Name],"Total Cost",SUMX(DISTINCT('Table'),'Table'[No. Unit]*'Table'[Per Unit]))

The result shows:

 

Hope this helps.

 

Best Regards,

Giotto Zhi

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-gizhi-msft  it works thanks a lot