Forum Discussion
Solved
Calculating category share by month
Hi there, I apologize if I misuse terms or am unaware of a feature availabe in DAX/Power BI as I suspect my issue may be additional data prep, but I'm completely stumped. I've linked the data fil...
Hi all,
aj1973 was very close with the solution, but a friend and I worked it out to be the following:
DIVIDE(SUM(Combined[Count]),CALCULATE(SUM(Combined[Count]),ALL(Combined[Device])))This can only work when there is a relationship between the date table and main data set ('Combined', in this case), because using the ALL function as a filter, allows you to keep the denominator (total device count in a given month) the same.
Hi Amine,
Apologies, I'm not doing a good job explaining myself. My goal would for the chart to look like the below but have the %'s add up to 100% for each month.
- aj1973
Community Champion
Is this close?
Yes that's the level of aggregraiton I need - but is it impossible to get it into a line chart?
Or do I have to create a secondary table (like the one you did) in Transform Data to feed these values?
- aj1973
here is the file.
https://drive.google.com/drive/folders/1AZwUoX41Sqyt9AS_j5V_yGgw2udTsO8u?usp=sharing
The chart you sent was not clear to me. try it yourself
