Count of Subcategories and Calculate its Average

[rbalza]

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!

 https://www.dropbox.com/s/xszrjtxt9oo8k76/sampledata.pbix?dl=0 

[amitchandak · Accepted solution]

@rbalza , Try a new measure like

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

[Jihwan_Kim · Accepted solution]

Hi, @rbalza 

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]

@Jihwan_Kim Kamsahamnida!

[amitchandak · Accepted solution]

@rbalza , Try a new measure like

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

[rbalza]

@amitchandak Thank you!