Microsoft Power BI DAX Tutorial – SUMX and MAX Function

Measure1 = MAX(rwa_get_licenses[MAX_PC_NUMBER])
Measure2 = SUMX(DISTINCT(rwa_get_licenses[CST_MAT]),[Measure1])
Measure3 = SUMX (VALUES (rwa_get_licenses[CST_MAT]); CALCULATE (rwa_get_licenses[MAX_PC_NUMBER])))
Measure4 = SUMX(SUMMARIZE(„CST_MAT“, rwa_get_licenses[CST_MAT], „MAX_PC_NUMBER“, MAX(rwa_get_licenses[MAX_PC_NUMBER])),[MAX_PC_NUMBER])

Leave a Reply

You must be logged in to post a comment.