Forum Discussion
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...
Hi @amalsp_ha,
Here are the steps you can follow：
1. Create measure.
Quantity_new =
CALCULATE(SUM('Table'[Quantity]))Value_new =
CALCULATE(SUM('Table'[Value]))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.
Hi,
Thanks for this, but I need to show this as a chart. The quantity has to go on the x axis and value to the y axis as I have shown in the chart I have given. As far as I know a measure cannot be added to an axis of a chart.
Amal