Forum Discussion

amalsp_ha's avatar
amalsp_ha
Frequent Visitor
5 years ago

Create summary table based on selected filters/slicers

Hi All,   I am trying to create a visualisation based on the quantity and purchase value with data close to the ones given bellow. But the quantity must be the sum of products purchased by a retail...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  @amalsp_ha,

 

Here are the steps you can follow：

1. Create calculated column.

Quantity_new =
CALCULATE(SUM('Table'[Quantity]),ALLEXCEPT('Table','Table'[Date],'Table'[ProductCode]))
Value_new =
CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Date],'Table'[ProductCode]))

2. Result.

 

You can downloaded PBIX file from here.

 

Best Regards,

Liu Yang

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

amalsp_ha's avatar
amalsp_ha
Frequent Visitor
5 years ago

Hi Liu Yang,

What I require is the 20 and the 32 in the x axis and the total for 20 and 32 respectively shown by the bar.

Please check the drawing of the bar chart I posted earlier.

Thanks

Amal