Forum Discussion
Simple table visual - display only rows that equal a measure.
Thanks for the replies from Ritaf1983.
Hi draxicle1 ,
Create two measure:
Maxdate = CALCULATE(MAX('Objective Scorecard'[Date of Evaluation]),ALL('Objective Scorecard'))Measure = IF(MAX('Objective Scorecard'[Date of Evaluation])=[Maxdate],1,0)
Then filter out data with measure equal to 1:
Result:
Best Regards,
Zhu
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Am I able to upload a redacted pbix file for you to look at ?
Hi draxicle1 ,
You can upload your file to a cloud storage (like OneDrive, Dropbox, Google Drive or Wetransfer for example) and paste the link to that storage location in the post. Please ensure sensitive data is removed and the correct access permission is set.
Best Regards,
ZhuHere is a link to some desensitised data.
https://drive.google.com/file/d/18pA8gWMv3fSneltTYfAVoL3DeoXy_vtG/view?usp=sharingPlease ignore or delete the "FY filter" and use the date slicer. The method works when 2024 is selected, but you'll notice that when you select 2023, that there are no "1" values and therefore nothing displays. When you take away the Maxdateequals1 filter from the visual, the "1"s reappear.
Hi there. I wondered if you have been able to look at the file I sent . I am still struggling with this problem.