How can I see the percentage for only the 2 axle column in a Matrix

[thechad13]

Greetings,

I am very frustrated and need some assistance. I have a Matrix that contains a list of employee ids. Each employee conducts inspections on various types of vehicles with different #s of axles over the course of a performance year. I have 3 values that I use in Matrix...Employee id #s, # of inspections & % of inspections by axle count. I can get the % breakdown within the Matrix (see attached pic) but I can't figure out how to only view the 2 axle results.

I would definitely appreciate any ideas even if it invlolves using a Table only, although I can't get that to work either!!! 

Thanks, 

Chad

[Daniel29195]

@thechad13 

sorry i couldnt understand your requirement,

is it possible to visualize your desired output like in excel or something ? 

that would be alot of help . 

thanks ,

[thechad13]

Hi Daniel...thanks for your reply. I have an spreadsheet that I can share but I can't find any way to upload an Excel file to this thread. I've attached a screenshot of the spreadsheet showing raw data > what I am looking for.

[Daniel29195 · Accepted solution]

@thechad13 i got you .

from the filter pane  ( filter on visual ) , select axles =  2

the measure %  = 

% =

var _current =

CALCULATE(

sum('Table (18)'[count])

)

var totat_per_badge =

CALCULATE(

    SUM('Table (18)'[count]),

    REMOVEFILTERS('Table (18)'[axle])

)

RETURN

DIVIDE(

    _current,

    totat_per_badge,

    0

)

let me know if this work out for you . 

best regards.

[thechad13]

Daniel...that totally works and is totally awesome! Thanks so much for your help!!!!!!!!!