Count number of products by the number they were sold

[gtamir]

Hi, I have a vizual with the product and the quantuty.

I want to count products by the quantity. Means how many products have quantity 2 and how many quantity of 3 Etc.

Should I export the visual and import it back and make the calculation, or I can do it in the visuals?

Giora

[v-jiascu-msft · Accepted solution]

Hi Giora,

Please refer to the demo in the attachment. 

1. Create a calculated table. 

Solution 1 =
SUMMARIZE (
    'Table1',
    Table1[ProductName],
    "Quantity", COUNT ( Table1[Quantity] )
)

2. Create a new Table visual.

Best Regards,
Dale

[BobBI]

Hi,

If you make your Quantity column as Text  and then Drag into Axis and do a count you product ,

Drag quantity into Axis  , Legend = Product  and Value = Count of Product

if this is not what you were expecting please share more details and sample data.

Thanks

SS

[gtamir]

@BobBI The table is in the vizual not in the model