Forum Discussion

jkaemmerling's avatar
jkaemmerling
Frequent Visitor
5 years ago
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...
Need Help
  • jkaemmerling's avatar
    jkaemmerling
    5 years ago

    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. 
jkaemmerling's avatar
jkaemmerling
Frequent Visitor
5 years ago

Hi Amine,

 

Your calculation is adding all months to 100% - the desired calculation is for each month to be 100% AND for the devices to be xx% of that 100% in each month. Then we can see how each device % changes across each month.