Forum Discussion

croz's avatar
croz
Regular Visitor
3 years ago
Solved

Calculating Penetration

Hi all,   I was wondering if anyone could help me with a dax/Powerbi problem, im currently trying to work out the penetration between 2 columns   i have a matrix which consits of two 3 column 'C...
DAX
DAX Commands
Penetration
powerbi
  • johnt75's avatar
    johnt75
    3 years ago

    You can create a measure like

    Penetration = 
VAR NumClients = CALCULATE( [Dis Client], ALLSELECTED('Table'[Category] ) )
VAR NumPolicies = [Dis Policy]
RETURN DIVIDE( NumPolicies, NumClients )
johnt75's avatar
johnt75
Super User
3 years ago

You can create a measure like

Penetration = 
VAR NumClients = CALCULATE( [Dis Client], ALLSELECTED('Table'[Category] ) )
VAR NumPolicies = [Dis Policy]
RETURN DIVIDE( NumPolicies, NumClients )
croz's avatar
croz
Regular Visitor
3 years ago

Hi John, 

this has worked perfectly!

Thank you very much and have a great day