Forum Discussion
Measure doesn't work after updating data
Hi, I have a measure count
I have a vacancy and it can have a lot of comments with one of several statuses like "OPEN", "CLOSED", "HOLD". Every comment has its own created date. In a measure I take the latest (max) created date and its status and put in a table with vacancies and its recent status. In a table it works correct. But it doesn't work in a card. It have to summarize all open statuses for all vacancies in card.
It worked fine until I refreshed dataset. Nothing was changed for that measure, data looks fine, i don't know what have I done.
2 Replies
Your filter looks a little adventurous. Might be worth refactoring with variables.
Please provide sanitized sample data that fully covers your issue. I cannot help you without meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi liza4567876,
Any update on this? Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
