Forum Discussion

NicolasHTR's avatar
NicolasHTR
Frequent Visitor
3 years ago

Summarize with userelationship

Dear all,

 

I have the following table:

 

The columns "Data Horas" and "Data Saldo" both have a relationship with a separate Calendar Table.

 

I want to have a summarized table with the sum of "Horas" on "Data Horas" and "Saldo Real" on "Data Saldo" for each "RES ID" and Date.

 

But for some reason, the sum of "Saldo Real" doesn't show up:

 

 

 

I tried the following code:

 

Availability =
    SUMMARIZE('Down History','Date'[Date],'Down History'[Res ID],"__Horas",CALCULATE(SUM('Down History'[Horas]),USERELATIONSHIP('Date'[Date],'Down History'[Data Horas])),"__Saldo Horas",CALCULATE(SUM('Down History'[Saldo Real]),USERELATIONSHIP('Date'[Date],'Down History'[Data Saldo])))
 
Can someone give me some help?
 
Thank you!!
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    NicolasHTR , Try like

    Availability =
    Addcolumns( SUMMARIZE('Down History','Date'[Date],'Down History'[Res ID],) ,"__Horas",CALCULATE(SUM('Down History'[Horas]),Filter('Down History', 'Date'[Date],'Down History'[Data Horas])),"__Saldo Horas",CALCULATE(SUM('Down History'[Saldo Real]),filter('Down History','Date'[Date],'Down History'[Data Saldo])))

     

    But this approach will miss the dates not avaiable because of default join

     

    Try to use summarize columns

     

    Availability =
    SUMMARIZECOLUMNS('Date'[Date],'Down History'[Res ID],"__Horas",CALCULATE(SUM('Down History'[Horas]),USERELATIONSHIP('Date'[Date],'Down History'[Data Horas])),"__Saldo Horas",CALCULATE(SUM('Down History'[Saldo Real]),USERELATIONSHIP('Date'[Date],'Down History'[Data Saldo])))