topic Re: Count of Subcategories and Calculate its Average in DAX Commands and Tips

Count of Subcategories and Calculate its Average

rbalza — Thu, 29 Apr 2021 03:32:38 GMT

Hi Power Bi SuperHumans,

How to count how many subcategories are there and calculate the average of the amount? Sample file is attached. Thanks for the help!

amitchandak — Thu, 29 Apr 2021 03:41:32 GMT

rbalza , Try a new measure like

countx(values(Table[Sub-Category]), [Total Invoice])

Jihwan_Kim — Thu, 29 Apr 2021 04:23:58 GMT

Please correct me if I wrongly understood your question.

If you are searching to get the Average Invoice amount per group, please try the below.

Each group -> shows the same amount as total invoice

Each invoice -> shows the average amount -> for instance, total amount of invoice01 divided by 5 groups.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

rbalza — Thu, 29 Apr 2021 07:44:03 GMT

Jihwan_Kim Kamsahamnida!

rbalza — Thu, 29 Apr 2021 07:51:04 GMT