Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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]))
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.
@daxer-almighty thank you for the response I will read the article and try to apply it to my model.
Here's something more about Calculation Groups and it's live: https://www.youtube.com/watch?v=a4zYT-N-zsU
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |