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.
Hi,
I have a measure below, which is working fine, except for the last filter condition. The filter attempts to find Month(date) and compare it with the selected month. However, this procudes the error "A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.". What is wrong and how to fix this?
Solved! Go to Solution.
HI,
You need to use Filter function after the SUM(Table1'[Net Value]).
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
HI,
You need to use Filter function after the SUM(Table1'[Net Value]).
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |