Forum Discussion
Multiple tables adding numeric number once per table
Hello, I have a question I just cant figure out. I have my powerbi with a field I named EWS Score in each table. I have my calculated field working across all tables and my measure. However, having 4...
I have the following up and running but my Attendance table has a score column. In Excel and SQL I can use a where clause (Where EWS Score =1) but in Dax how would I apply this to my attendance line only?TOTAL EWS POINTS =
( SUMX(
VALUES(Attendance[OTHER-ID]),
(CALCULATE(DISTINCTCOUNT(Attendance[OTHER-ID]))
)) + (SUMX(
VALUES('Discipline Datamining'[Other ID]),
CALCULATE(DISTINCTCOUNT('Discipline Datamining'[Other ID]))))
+ (SUMX(
VALUES('TEST_SCORES_ELAMATLEVELS'[Other ID]),
CALCULATE(DISTINCTCOUNT('TEST_SCORES_ELAMATLEVELS'[Other ID]))))
+ (SUMX(
VALUES('EWS POSTED GRADES'[Stdt ID]),
CALCULATE(DISTINCTCOUNT('EWS POSTED GRADES'[Stdt ID]))))
)