Counting Rows in Column

[Heinrich]

Hello

I have a table with column

A = Company

B = User Count

C = Product Windows 10

or Product Windows 11

I would like to have a visual who shows

Column 1 = Company

Column 2 = Quantity User

Column 3 = Quantity of Windows 10

Column 4 = Quantity of Windows 11

Column 3 and Column 4 should be taken from C

Regards

Heinrich

[Sahir_Maharaj · Accepted solution]

Hello @Heinrich,

Can you please try the following measures for Quantity of Windows 10 and Windows 11

Quantity Windows 10 = 
SUMX(
    FILTER(
        Data,
        Data[Product] = "Product Windows 10"
    ),
    Data[User Count]
)

Quantity Windows 11 = 
SUMX(
    FILTER(
        Data,
        Data[Product] = "Product Windows 11"
    ),
    Data[User Count]
)

[Heinrich]

Hello Sahir_Mahraj
Thank you very much.
I tried it with a Matrix and this worked but will keep your solution for future tasks.
Thanks
Heinrich