Percentage of values by category

[Syndicate_Admin]

Hello everyone

I would like to know if someone can help me with the addition of a card that indicates the percentage of shipments per month as 100%, and go calculating by product category to which percentage corresponds its amount of shipment separately. For example, I have the following table:

Category	Shipments	my
Cecinas	5.450	September
sweets	3.240	September
cereals	1.392	August
beverages	897	July
Meats	1.200	July

For this case, if I add a month filter, where I filter by September and I need to show the total shipments of that month on one card, and on another card that shows me the percentage of the total shipments of the month of September or another filtered month (take the case September 5,450 + 3,240 = 8,690 --> 100%), and that later allow me to filter by category in a matrix, and that it indicates to me, for example, the percentage of shipments of sweets (when clicking this category on the matrix) within the total of 100% (percentage of 3,240 within 8,690 ------->37.2%)

Thank you very much in advance.

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

I have created a simiple sample, please refer to it to see if it helps you.

Create measurs.

Measure =
VAR _1 =
    CALCULATE (
        SUM ( 'Table'[Shipments] ),
        FILTER ( ALL ( 'Table' ), 'Table'[my] = SELECTEDVALUE ( 'Table'[my] ) )
    )
VAR _all =
    SUMX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[my] = SELECTEDVALUE ( 'Table'[my] )
                && 'Table'[Category] = SELECTEDVALUE ( 'Table'[Category] )
        ),
        'Table'[Shipments]
    )
RETURN
    _all / _1

Measure2 =
VAR _1 =
    CALCULATE (
        SUM ( 'Table'[Shipments] ),
        FILTER ( ALL ( 'Table' ), 'Table'[my] = SELECTEDVALUE ( 'Table'[my] ) )
    )
VAR _all =
    SUMX (
        FILTER ( ALL ( 'Table' ), 'Table'[my] = SELECTEDVALUE ( 'Table'[my] ) ),
        'Table'[Shipments]
    )
RETURN
    _all / _1

If I have misunderstood your meaning, please provide more details with your desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.