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
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.