Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |