Row % from Total

[Anonymous]

looking to calculate the % of a row total against the total

Product Group is a column
Overall Defects is the Count of a Column based on whether type is a "Defect"

Open > 6 months is a measure

Running Age (Open > 6 months) =

CALCULATE(

    COUNTROWS(Items'), FILTER('Items','Items'[Running Age in Days (Open Items)] > 183))

what i am trying to achieve is get the row % of Open > 6 months figure from the total as per below

thanks

[Washivale · Accepted solution]

Hi @Anonymous ,

try below measure

PercentagevsTotal =
var total = Calculate([OverallDefects], All([Product Group]))
Return
Divide([Open > 6 months)], total, blank())

let me know if it works.

Thanks,

Washivale

[Anonymous]

@Washivale 
thankyou
that worked great

so simple