Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Get Last Non Blank Score Per SubCategory then Average it all up
DataModel:
In Measuress Table I have Score, I want to get the last non blank value per Subcategory
I managed to get the last non blank value per subcategory, but when it comes to Category level the result becomes wrong
I am getting 33% while it should be 28%
Measures_Score_AVG_Score =
CALCULATE (
AVERAGE ( Measuress[Measure_Score] ),
FILTER (
Measuress,
Measuress[EndDate]
= CALCULATE (
LASTNONBLANK ( Measuress[EndDate], TRUE () ),
FILTER ( Measuress, Measuress[Measure_Actual] <> BLANK () )
)
)
)
PBIX FILE : https://gofile.io/d/R2ABeq
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
28% is wrong. The score for Toyota was on Jan 1, not on Feb 1, and should therefore not be considered.
33% is correct because the lastnonblank date for "Cars" is Feb 1 20, and it has two values of .5 and .15, and the average of these is .325
User | Count |
---|---|
83 | |
77 | |
71 | |
70 | |
54 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |