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 a calculated table.

Table 2 =
SUMMARIZE(
'Table','Table'[Retailercode],    
"Quantity",CALCULATE(SUM('Table'[Quantity]),FILTER('Table','Table'[ProductCode]="PROD-002" || 'Table'[ProductCode]="PROD-003")),
"Value",CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[ProductCode]="PROD-002" || 'Table'[ProductCode]="PROD-003")))

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,

Thank you for the reply and the solution, but my issue here is that the product codes are not fixed, these are to be selected from a slicer. Also there are other slicers like date, geography. So I cannot use fixed products in the table creation dax. Today it might be PROD-002 & PROD-003 tomorrow it might be PROD-001 & PROD-002.

Hope you have got an idea about my requirment. My apologies if I was not clear in my earlier post.

Amal

  • dvnnnaidu's avatar
    dvnnnaidu
    Icon for Helper II rankHelper II
    5 years ago

    HI Amal,

     

    Just checking if you have got the solution for your problem. I have exact same scenario to deal with and strugling to fix.