Create a measure to visualize percentage

[harsha1234]

Hi All,

I have these columns in the power query editor:

Name            Status

Adam            Registered

Bob               Not Registered

Steve             Registered

Katie             Not Registerd

Kirk               Not Registered

I'd like to create a card to visualize ther percent of people registered? I believe I need to create a measure but I'm having issues doing that. Can someone please help me with this?

Thanks in advance 🙂

-H

[TomMartens]

Hey,

I guess this should do the work:

name of the measure = 
var theregisteredones = 
CALCULATE(
COUNT('table'[name])
,ALL('table')
,'table'[status] = "Registered")
var allpeople = 
CALCULATE(
COUNT('table'[name])
,ALL('table')
)
return DIVIDE(theregisteredones, allpeople, BLANK())

Hopefully this is what you are looking for

Regards,

Tom

[harsha1234]

Hey Tom,

Suppose I have this:

Name        Status                             Type

Adam         Registered                     A

Bob            Not Registered              B

Steve          Registered                     B

Chris           Not Registered              A

Katie            Not Registered            A

And I only want to calculate people category A...how would I modify the above measure you provided?

[TomMartens · Accepted solution]

Hey,

just insert this little row to the filter section of each CALCULATE

,'Table'[Type] = "A"

Regards,

Tom

[harsha1234]

Very nice!! Thanks Tom

[harsha1234]

Thanks!!