Forum Discussion
Solved
DAX help
Hello, I am working with a very small data set (see image) and I am trying to find percentages based on filter criteria using DAX. 1. My first equation was to find the total count of each animal,...
Hi margeausoboti,
You want to create a calculated column to get the percentage? If it is, please create calculated columns using the fomulas, and check if it works fine.each type percentage = CALCULATE ( SUM ( Table[Count] ), ALLEXCEPT ( Table, Table[tipo] ) ) / SUMX ( ALL ( Table ), Table[Count] ) each Animal percentage = CALCULATE ( SUM ( Table[Count] ), ALLEXCEPT ( Table, Table[Animal] ) ) / SUMX ( ALL ( Table ), Table[Count] ) each Color percentage = CALCULATE ( SUM ( Table[Count] ), ALLEXCEPT ( Table, Table[Color] ) ) / SUMX ( ALL ( Table ), Table[Count] )Don't hesitate to ask if you have any other issues.
Best Regards,
Angelia
Thank you everyone for all of your help! I went back and checked it again, I had another filter on my chart. After removing the filter, Angelia's syntax is exactly what I needed to resolve the issue. Can anyone recommend a course that I can take to learn DAX? I am a new user of DAX and would liketo become a super user! Thanks!
A time ago I found a good youtube channel about Power BI, every fridays there is a new topic about DAX. The Curbal woman has become my favourite : ) . Enjoy it !
Thank you!