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.
I want my KPI to show the first sales number by Created Date per each project ID.
Any suggestion on how I could fix this?
For the attached sample, the expected outcome would be for the Goal value (First) to show 5.50M instead of 4.9M since that is the first Sales 1 of Project ID 28.
https://www.dropbox.com/s/viwu36d32e3suq2/saleshistorysample.pbix?dl=0
Solved! Go to Solution.
Hi, @Anonymous
It’s my pleasure to answer for you.
According to your description,I think need to create a index column in PQ first,because your date column has duplicate data.Then create a measure.
Like this:
First Value 1 =
VAR a =
MINX (
FILTER (
ALL ( data ),
[Project ID] = SELECTEDVALUE ( data[Project ID] )
&& [Sales 1] <> BLANK ()
),
[Index]
)
RETURN
MAXX ( FILTER ( ALL ( data ), [Index] = a ), [Sales 1] )
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
It’s my pleasure to answer for you.
According to your description,I think need to create a index column in PQ first,because your date column has duplicate data.Then create a measure.
Like this:
First Value 1 =
VAR a =
MINX (
FILTER (
ALL ( data ),
[Project ID] = SELECTEDVALUE ( data[Project ID] )
&& [Sales 1] <> BLANK ()
),
[Index]
)
RETURN
MAXX ( FILTER ( ALL ( data ), [Index] = a ), [Sales 1] )
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That actually worked! Thank you Janey. @v-janeyg-msft
Any thought on fixing the trend line there?
As you can see, the correct trend line would be the one from the second graph (color green) rather than the first graph (color red).
I tried to write the function as a column instead of a measure. That didn't work.
Any thoughts?
Greatly appreciated.
Hi, @Anonymous
The green graph was presented by the wrong goal value, and it will change after the goal value is corrected.If you feel not good, it may be that your data is not suitable for using KPIs.You need to adjust the data first.
Here is the KPI link.You can check it.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Create a new measure like this and try
first value =
sumx(values(Table[project id]), firstnonblankvalue(Table[Created Date], Sum(Table[Sales])))
Thanks for sharing that!
I tried that measure and it still didn't show the right value for the target goal in the KPI.
It still shows as 4.9M instead of 5.5M.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |