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,
I'm trying to solve an issue that's VERY similar to https://community.powerbi.com/t5/Desktop/Displaying-percentage-of-total-for-multiple-legends-in-a/td...; in fact this solution used to work for me when all the variables were in the same table, but I've had to put the example in the link's equivalent of "campus" in the legend in a separate (but linked) data table.
Can anyone help me out? I've been losing my mind trying to work this out! I can't just use %GT because i want to compare programmes next to each other, rather than aggregate the cohort.
Happy to clarify further if needed.
Here's my little model:
This is what I need to happen:
1 Income = (COUNTX('Full Dataset_2018-2019', [00 Gross Income]))
1 Total Incomes = CALCULATE([1 Income ], ALLEXCEPT('Full Dataset_2018-2019', 'Full Dataset_2018-2019'[Programme Code], 'Full Dataset_2018-2019'[Subject]))
1 Perc of Income Total = DIVIDE([1 Income], [1 Total Incomes],0)
Would be eternally grateful for some assistance!
Hi @thmpsne ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @thmpsne ,
We can try to create a measure using following formula to meet your requirement:
Perc of Income Total =
DIVIDE (
CALCULATE ( SUM ( '1 Online_2018_2019'[Income] ) ),
CALCULATE (
SUM ( '1 Online_2018_2019'[Income] ),
ALLEXCEPT ( '1 Online_2018_2019', '1 Respondent'[Subject] )
),
0
)
If it does not work, please try to set the cross filter direction between the middle table and right table to both.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |