Forum Discussion
Row % from Total
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
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
