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, per type and color = 161.2. Next, I need to find the percentage per animal (count of animal divided by the total number of animals).3. Last, I need to find the percentage per animal type (count of type divided by the total number of animals). I have tried using different methods for this equation, but still am not getting the correct formula. Thank you!

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

DAX help | Microsoft Fabric Community

Forum Discussion

Related content

Dax

DAX Formula Help

DAX

DATEDIFF DAX

DAX Query help