Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Regarding Matrix Column Total Calculation based on date selection

Hi, I have to create a DAX which calculates the total of a column based on date and then divide the row total of that with the total value. eg.  So, i want to create a measure which take amo...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thank you Guys for the help..

    I also tried using this :

     

    Total = CALCULATE(Table[Amount],ALLEXCEPT(Table,Table[Date))

     

    and it worked !!

     

    Thanks for your help as well.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi

 

first measure , sales by day by variety==>

Total sales = sum(Fruit[Amount])
 
second measure , Total sales for the day==> 
Total sales day = calculate(sum(Fruit[Amount]),REMOVEFILTERS(Fruit[Variety]))
 
Third measure, calculate %
%sales = divide(Fruit[Total sales],Fruit[Total sales day],0)