Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

Applied bars - percentage

New to POWER_BI. I'm doing a graph of stacked boards to get vehicle types/percentage. the data I have is Table1 [POLIZA] Table 1 [Vehicle Type] I'm trying to do a measure by nesting Average and c...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Don'@Syndicate_Admin,

    You might try:

    measure = calculate(count('table'[poliza]),allexcept('table','table'[type]))/CALCULATE(COUNTROWS('Table'),ALL('Table'))


    Best regards

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Don'@Syndicate_Admin,

You might try:

measure = calculate(count('table'[poliza]),allexcept('table','table'[type]))/CALCULATE(COUNTROWS('Table'),ALL('Table'))


Best regards

Jay