Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello Experts,
I have data set like below
TypeOfCall | Year | Quarter | AttnTimeNew |
Urgent | 2020 | Q1 | 6.2 |
Non-Urgent | 2020 | Q3 | 9.1 |
Urgent | 2020 | Q2 | 18 |
Non-Urgent | 2020 | Q1 | 20 |
I am writing a Dax measure using filters for AttnTimeNew.
com-test = CALCULATE(COUNTA('VW_Water'[CC_MASTER__ID]), FILTER('VW_Water','VW_Water'[AttnTimeNew]>=18)).
For this filter, it should give the result of "2" as I'm using greater than or equal operators. But it gives results as "1". If I change above Dax query as 17, FILTER('VW_Water','VW_Water'[AttnTimeNew]>=17), then it will give the result of "2".
The source column is in decimal number.
If I change it to a whole number I can see the results correctly. Hope you will help to resolve this issue.
thanks
Solved! Go to Solution.
Hello-
I recreated your table (I added a column called CC_MASTER_ID, since that's what your measure is counting):
For the measure, I copied your measure:
and for the result, I get the expected "2".
Hello-
I recreated your table (I added a column called CC_MASTER_ID, since that's what your measure is counting):
For the measure, I copied your measure:
and for the result, I get the expected "2".
It seems this was data related problem...
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
13 | |
12 | |
11 | |
9 |
User | Count |
---|---|
65 | |
20 | |
20 | |
17 | |
11 |