Hi,
This is the first time i work with Power BI and created a "new quick measure"
And this works in the table except for the TOTAL
so i saw something on the internet with SUMX but i do something wrong i guess because it didn't work:
Can anyone help me out, i guess this is basic knowledge but like i said power bi is new for me
Kind regards,
This is the first time i work with Power BI and created a "new quick measure"
- Hours * Cost
Code:SUM('DD_BE_QT_SMO_Services'[Cost]) * SUM('DD_BE_QT_SMO_Services'[Amount_Of_Days]) - Hours * Rate
Code:SUM('DD_BE_QT_SMO_Services'[Rate]) * SUM('DD_BE_QT_SMO_Services'[Amount_Of_Days])
And this works in the table except for the TOTAL
so i saw something on the internet with SUMX but i do something wrong i guess because it didn't work:
Code:
SUMX(VALUES(DD_BE_QT_SMO_Services[Amount_Of_Days])) * SUMX(VALUES(DD_BE_QT_SMO_Services[Cost]))Kind regards,
Last edited by a moderator:
