cancel
Showing results for
Did you mean:
Frequent Visitor

## 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 amount total value based on date and calculate amount(%) by dividing individual row by total amount in the same way as shown in table.

Kindly suggest.

1 ACCEPTED SOLUTION
Frequent Visitor

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.

3 REPLIES 3
Frequent Visitor

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.

Super User

Hi @NiMa ,

You could create a measure as below:-

``````Measure =
VAR total =
CALCULATE (
SUM ( 'Table (2)'[Amount] ),
ALL ( 'Table (2)'[Variety] ),
'Table (2)'[Date] = MAX ( 'Table (2)'[Date] )
)
RETURN
DIVIDE ( MAX ( 'Table (2)'[Amount] ), total )
``````

Refer attached file.

BR,

Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Impactful Individual

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)

Announcements