Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

TotalCost based on Table or Matrix Value

I have pivot table in excel and I have calculated total cost based on the values of my calculations in the pivot table and I would do samething in excel but I am not sure how, Please below my sample ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    for me to be able to try the formula you supplied, i need to derive number of attendee: i used counifs please sample below 

    =COUNTIFS(B:B,B2,C:C,C2,A:A,A2),please help with Dax for the countifs

    DateNameStatusOutput
    11/06/2019 07:00CASEnrolled9
    11/06/2019 07:00CASEnrolled9
    11/06/2019 07:00CASEnrolled9
    11/06/2019 07:00CASEnrolled9
    11/06/2019 07:00CASEnrolled9
    11/06/2019 07:00CASEnrolled9
    11/06/2019 07:00CASEnrolled9
    11/06/2019 07:00CASEnrolled9
    11/06/2019 07:00CASEnrolled9
    10/06/2019 08:30PATEnrolled6
    10/06/2019 08:30PATEnrolled6
     PATEnrolled0
    19/05/2019 23:00PATEnrolled1
    10/06/2019 08:30PATEnrolled6
    10/06/2019 08:30PATEnrolled6
    10/06/2019 08:30PATEnrolled6
    10/06/2019 08:30PATCancelled1
    10/06/2019 08:30PATEnrolled6
    10/07/2019 23:00CASEnrolled1
    10/07/2019 23:00CAS - CLONED(25/07/2019)Enrolled2
    10/07/2019 23:00CAS - CLONED(25/07/2019)Enrolled2

     

    amitchandak 

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

for me to be able to try the formula you supplied, i need to derive number of attendee: i used counifs please sample below 

=COUNTIFS(B:B,B2,C:C,C2,A:A,A2),please help with Dax for the countifs

DateNameStatusOutput
11/06/2019 07:00CASEnrolled9
11/06/2019 07:00CASEnrolled9
11/06/2019 07:00CASEnrolled9
11/06/2019 07:00CASEnrolled9
11/06/2019 07:00CASEnrolled9
11/06/2019 07:00CASEnrolled9
11/06/2019 07:00CASEnrolled9
11/06/2019 07:00CASEnrolled9
11/06/2019 07:00CASEnrolled9
10/06/2019 08:30PATEnrolled6
10/06/2019 08:30PATEnrolled6
 PATEnrolled0
19/05/2019 23:00PATEnrolled1
10/06/2019 08:30PATEnrolled6
10/06/2019 08:30PATEnrolled6
10/06/2019 08:30PATEnrolled6
10/06/2019 08:30PATCancelled1
10/06/2019 08:30PATEnrolled6
10/07/2019 23:00CASEnrolled1
10/07/2019 23:00CAS - CLONED(25/07/2019)Enrolled2
10/07/2019 23:00CAS - CLONED(25/07/2019)Enrolled2

 

amitchandak 

 

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous 

 

Try as a new column

 

Output = countx(filter(Table,Table[Name] =earlier(Table[Name]) && Table[Status] =earlier(Table[Status])),Table[Date])