Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello. I'm tryiing to find
=SUMX(Filter(RELATEDTABLE('Work Orders1'),'Work Orders1'[WO Type]="Cashout"),'Work Orders1'[WO Type]="Cashout")
Solved! Go to Solution.
Hi, @ammartino44
From your formula, the data type of column 'Work Orders1'[WO Type] is text, while SUMX function evaluates to numbers or dates and cannot work with values of type String. Beside, the correct syntax of SUMX is:
SUMX(<table>,<expression>)
In your scenario, the formula might be like :
=SUMX(FILTER(RELATEDTABLE('Work Orders1'),'Work Orders1'[WO Type]="Cashout"),ColumnName)
Best regards,
Yuliana Gu
Hi, @ammartino44
From your formula, the data type of column 'Work Orders1'[WO Type] is text, while SUMX function evaluates to numbers or dates and cannot work with values of type String. Beside, the correct syntax of SUMX is:
SUMX(<table>,<expression>)
In your scenario, the formula might be like :
=SUMX(FILTER(RELATEDTABLE('Work Orders1'),'Work Orders1'[WO Type]="Cashout"),ColumnName)
Best regards,
Yuliana Gu
Gonna need more info on this one but... your formula does "look weird". The general form of SUMX is:
=SUMX(Table1, Expression)
It walks each row of the Table1, and evaluate the Expression... then adds the results together.
Your expression is : 'Work Orders1'[WO Type]="Cashout"
That seems like a weird expression!
Hi there
I know this might be a simple question, but have you created the relationship between your tables?
Also when using the related table, from memory you can only reference the RelatedTable on the many side of the relationship (NOTE: This is off the top of my head, it might be the other way around!)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |