79549830

Date: 2025-04-02 06:27:10
Score: 2
Natty:
Report link

I want to share another solution/measure that works:

Share% = 
VAR denom = CALCULATE(
    SUM(Table1[Value]),
    ALL('Table1'[Financial KPI]),
    'Table1'[Financial KPI] = MAX(Table1[Denominator])
)
VAR num = CALCULATE(
    SUM(Table1[Value]),
    'Table1'[Financial KPI] = MAX(Table1[Financial KPI])
)
RETURN
    DIVIDE(
        num,
        denom,
        0
    )
Reasons:
  • RegEx Blacklisted phrase (1): I want
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: latitude21