Forum Discussion

Brian_Hunt's avatar
Brian_Hunt
Frequent Visitor
4 years ago
Solved

Measure calculation for subtotal based on sub-hierarchy grouping on condition

I  have a column of data that counts orders by employee, and another that counts if the order has been completed. I created a measure that calculates the completion rate and dropped all this in a mat...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Brian_Hunt ;

    You could create measures as follow:

     

    teams at >50% = CALCULATE(COUNT('Table'[Level3]),FILTER('Table',[Complete rate]>=0.5))
    of teams >50% = 
IF(ISINSCOPE('Table'[Level3]),BLANK(),
[teams at >50%]/COUNT('Table'[Level3]))

     

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HoangHugo's avatar
HoangHugo
Icon for Solution Specialist rankSolution Specialist
4 years ago

Hi

I think

measure

       %team =
           var   count_employee = DISTINCTCOUNT (employee)
           var   count_employee>50% =   CALCULATE ( COUNTROW(SUMMARIZE (date,employee)), COMPLETE rate >=50%)
           var  group/department = SELECTEDVALUE (employee)

            return

             if ( group/department <> blank (), blank (), count_employee>50% / count_employee)

 

Brian_Hunt's avatar
Brian_Hunt
Frequent Visitor
4 years ago

Thank you. I'll give this a try and let you know.