Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm having difficulties summing up the following table:
MyTable =
Solved! Go to Solution.
@CarlsBerg999 So this doesn't work?
MyTable =
VAR __Table =
FILTER(
CALCULATETABLE(
VALUES('Table'[Value (€)]),
USERELATIONSHIP(DateTable[Date],'Table'[Start Date])),
ISEMPTY(CALCULATETABLE('Table',
'Table'[Attribute mod.]="Quote requested",
USERELATIONSHIP(DateTable[Date],'Table'[Start Date]))))
VAR __Result = SUMX(__Table,[Value (€)])
RETURN
__Result
@CarlsBerg999 So this doesn't work?
MyTable =
VAR __Table =
FILTER(
CALCULATETABLE(
VALUES('Table'[Value (€)]),
USERELATIONSHIP(DateTable[Date],'Table'[Start Date])),
ISEMPTY(CALCULATETABLE('Table',
'Table'[Attribute mod.]="Quote requested",
USERELATIONSHIP(DateTable[Date],'Table'[Start Date]))))
VAR __Result = SUMX(__Table,[Value (€)])
RETURN
__Result
Unfortunately this only works in a visual where there are ID's for each row. The summarizing of these does not add up correctly. I'm not quite sure if report level filters are causing this.
Edit:
--> Answer to this was yes. Report level filters were the root cause. VALUES() -part of the formula was returning an incorrect value for the filter context. Thanks for the help!
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |