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 s...
Need Help
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])))