Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have spent days on this and cannot figure it out. I hope someone can help, please
I'm tracking skills so my model has skillnames, achieved levels, dates and persons name. (This is just a test - my actual table have millions of records but behaves the same)
Im using this measure to get the latest value of each skill for each person:
I am then using this measure to count up the number of each skill level:
Solved! Go to Solution.
@justlearning50 , try like
Countrows(filter(Sheet1, not(isblank([Latest result])) && [Latest result] =0))
@justlearning50 , try like
Countrows(filter(Sheet1, not(isblank([Latest result])) && [Latest result] =0))
Thank you @amitchandak . That worked.
Why is this need for 0 only? is it a case that there is a default blank for the rows that are not the latest score, and the measure was reading these as 0? If I create a table with the achieved score and the latest score, I only see the rows with the latest score not all the rows with a blank.
Thank you again.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
75 | |
72 | |
39 | |
29 | |
27 |
User | Count |
---|---|
97 | |
96 | |
58 | |
44 | |
40 |