Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I have below expression , dont know why it unable to work , as it display null :-
Solved! Go to Solution.
Hi Paul,
I'm not sure what you're expected result is but it looks to me like the [_rate] is measure is wrong because it's getting the RATE from the AR table when I think you shoudl be getting it from the Rate table.
I've amended the measure to this
_rate = SUMX(FILTER('RATE',[SOURCE]=SELECTEDVALUE('RATE'[SOURCE])),[RATE])
Regards
Phil
Proud to be a Super User!
Hi Paul,
I'm not sure what you're expected result is but it looks to me like the [_rate] is measure is wrong because it's getting the RATE from the AR table when I think you shoudl be getting it from the Rate table.
I've amended the measure to this
_rate = SUMX(FILTER('RATE',[SOURCE]=SELECTEDVALUE('RATE'[SOURCE])),[RATE])
Regards
Phil
Proud to be a Super User!
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |