Forum Discussion
Syndicate_Admin
Administrator
AdministratorApplied 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 count functions to get the percentage out but I don't find out with it Can you help me?
You might try:
measure = calculate(count('table'[poliza]),allexcept('table','table'[type]))/CALCULATE(COUNTROWS('Table'),ALL('Table'))
Best regardsJay
3 Replies
- parry2k
Super User
Syndicate_Admin can you put some sample data and expected output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 
Syndicate_AdminPlease, do you know how I can get the percentage of moths for each type of vehicle on the stacked bars. Here:
You might try:
measure = calculate(count('table'[poliza]),allexcept('table','table'[type]))/CALCULATE(COUNTROWS('Table'),ALL('Table'))
Best regardsJay
