Forum Discussion

harsha1234's avatar
harsha1234
Regular Visitor
8 years ago
Solved

Create a measure to visualize percentage

Hi All,   I have these columns in the power query editor:   Name            Status Adam            Registered Bob               Not Registered Steve             Registered Katie             N...
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

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

     

    ,'Table'[Type] = "A"

    Regards,

    Tom

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
8 years ago

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's avatar
harsha1234
Regular Visitor
8 years ago

Thanks!!