Standard Rate PowerBI

Hi tshapiro18 ,

To solve your problem, here are my test data, I think you can follow these steps:

1.You can create measure by using DAX:

weighted percentage = 
    var _pre = CALCULATE(
     MAX('Table'[Numerator]),
     FILTER('Table','Table'[Measure] = 10.2 && 'Table'[Gender] = 1 && 'Table'[Age group]=4 && 'Table'[Social economic]=3)
     )
     var _last = CALCULATE(
     MAX('Table'[Denumerator]),
     FILTER('Table','Table'[Measure] = 10.2 && 'Table'[Gender] = 1 && 'Table'[Age group]=4 && 'Table'[Social economic]=3)
     )
     VAR percentage = _pre / _last
     VAR weightedpercentage = DIVIDE(_last,CALCULATE(
        SUM('Table'[Denumerator]),
        FILTER('Table','Table'[Age group]=4 )
     ))
     RETURN
     weightedpercentage

2.final output

^{I hope the method as above helps, if not, please provide more details of the problem.}

^{In order for you to solve the problem faster, you can refer to the following documentation}

How to Get Your Question Answered Quickly - Microsoft Fabric Community

^{Best Regards,}

^{Albert He}