I created a new measure using summarize. I want the station slicer is not to change the result of the ntrips measure. I used the removefilters command, but I could not achieve the desired result.
Sample file is here https://1drv.ms/u/s!AsQNupGZsOP-sRIvpROXCVhKtkjk?e=8nlfpQ
Go to Solution.
@coldfire , Try like
NTrips =var a = SUMMARIZE(calculateTable('Table', all('Table'[STATION]) ),'Table'[LINE],'Table'[DIRECTION],'Table'[DATE],"ntrips", CALCULATE(MAX('Table'[TRIPS])))returnsumx(a,[ntrips])
Best in such case to use independent table for STATION
Power BI Abstract Thesis: Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
View solution in original post
After creating a independent station table, the issue was resolved. thank you so much.
thx for quick answer but ntrips value change when i select multiple date with station.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!