Adding Total Line in the same Line Chart that is broken down by different Attributes

[Anonymous]

Hi there,

Just want to understand if there is a way to show a total % line in the same line chart that break downs the data with different attributes. Just created a dummy data table to explain further. thanks in advance

Table Name: Person Data

Metric required: Female participation rate in each attiribute i.e. counrty, emp type etc. pls see follwoing example

Measure:  Female Participation =DIVIDE(CALCULATE(DISTINCTCOUNT('Person Data'[Person ID]),'Person Data'[Gender]="Female"),DISTINCTCOUNT('Person Data'[Person ID]))

with this measure I can show total line or break it down by some categories but can't show all in one line chart.

To include Total line in same chart I need to create seperate measures:

Female %: DIVIDE(CALCULATE(DISTINCTCOUNT('Person Data'[Person ID]),'Person Data'[Gender]="Female"),DISTINCTCOUNT('Person Data'[Person ID]))

Female % Aus: CALCULATE([Female Participation],'Person Data'[Country]="Aus")

Female % NZ:  CALCULATE([Female Participation],'Person Data'[Country]="NZ")

[daxer-almighty]

You can use Calculation Groups to create versions of all measures that will be insensitive to any set of attributes you want. This would be the simplest and most elegant solution out there.

[Anonymous]

@daxer-almighty thank you for the response I will read the article and try to apply it to my model.

[daxer-almighty]

Here's something more about Calculation Groups and it's live: https://www.youtube.com/watch?v=a4zYT-N-zsU

[Anonymous]

@daxer-almighty thanks again really appreacite your help around that.