Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |