Forum Discussion
How to create calculated table removing filter context
Hello, I have filter used on all page. I've been able to create a measure removing this filter from specific column, however I struggle to create a calculated table based on that. My measure: ...
PatMic090 , Table can not use filter or slicer values.
You can create a column like
COUNTX(filter( LocationReporting, LocationReporting[League] = earlier('LocationReporting'[League])),LocationReporting[LocationReportingDesc])
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
- Thanks for your reply. I see that the function you mentioned worked, but it's counting the stores. Do you know how the actual names can be returned in a column? Sorry if I misunderstood something.
