Divide with filter on specific value

[mrvega]

Hi,

I want to divide the values of site 1, 2 etc. against the value of "Career Services and Development" in a matrix table. All of the values are contained within the same column of my dataset; and all of the Clean Names are stored in their own respective column. I know I need to filter and divide, but I either keep getting 'Infinity', or only get "Career Services and Development" appearing on its own as 100% value with what I have tried so far.

I want to see all sites displayed with their percentage value. My end results should basically be:

Clean Name                                   | July

Career Services and Development | 100%

Site 1                                              | 43.6%

Site 1                                              | 21.8%

etc.

Many thanks and apologies for the noob question!

[Anonymous · Accepted solution]

HI @mrvega,

You can try to use following measure if it works for your requirement:

Measure =
VAR total =
    CALCULATE (
        SUM ( Table[Amount] ),
        ALLSELECTED ( Table ),
        VALUES ( Table[Month] )
    )
VAR current =
    CALCULATE (
        SUM ( Table[Amount] ),
        ALLSELECTED ( Table ),
        VALUES ( Table[Clean Name] ),
        VALUES ( Table[Month] )
    )
RETURN
    DIVIDE ( current, total, BLANK () )

Please share some sample data for test if above not help.

Regards,

Xiaoxin Shemg