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.
Hello,
The KPI shows different disances when I automate indicator and target. But when I set them manually, it shows a correct distance. Please tell me where my mistake is.
Input data:
I have a table with prices which update weekly. In KPI I need to show the last day price as an indicator and the first day price as a target. The KPI difference will be a subtraction between the last day and the first day.
There are also filters on this visual: a slicer " Delivery date" and a visual filter " Product used in charts"
1) in this measure I set dates manually and it shows the difference correctly:
But every week I need to enter new dates manually, so I decided to automate.
2) So I changed DAX:
KPI shows a difference = 0.
Where is my mistake?
cahnge MAXX > MAX & MINX > MIN hope it will work
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
Thank you.
1) It DID NOT work:
2) I noticed, that the difference is not calculated correctly, because Target measure cannot detect the last day automatically. Hence it must be written like this, manually:
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 |
---|---|
116 | |
102 | |
78 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |