Summarize with userelationship

[NicolasHTR]

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!!

[amitchandak]

@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])))