Different dimensions same table

[Anonymous]

This expression only works with one dimension.

Count({<[Consumer Type]={'Guest'}>}distinct[Product Type])

However I want to count the quantities of two different dimensions in the same table to look like this…

Priority Items	Quantity
Drink	7
Food	5
Cioppino	2

Here is my data

Purch No	Consumer Type	Product Name	Product Type
00020	Employee	Negroni	Drink
00019	Guest	Daiquiri	Drink
00018	Employee	Martini	Drink
00017	Employee	French 75	Drink
00016	Guest	Mint Julep	Drink
00015	Employee	Sidecar	Drink
00014	Guest	Sidecar	Drink
00013	Guest	Pimm's Cup	Drink
00012	Employee	Gimlet	Drink
00011	Guest	Mimosa	Drink
00010	Guest	Mimosa	Drink
00009	Employee	Whiskey Sour	Drink
00008	Guest	Manhattan	Drink
00007	Guest	Cheeseburger	Food
00006	Guest	Reuben	Food
00005	Employee	Po'boy	Food
00004	Guest	BLT	Food
00003	Employee	BLT	Food
00002	Guest	Cioppino	Food
00001	Guest	Cioppino	Food

[Channa]

add chart

Dimension:Product type

=Count(  {<[Consumer Type]={'Guest'}>}[Product Type])