Incorrect Measure Total

Hi Anonymous,

Based on my test, we can take the following steps to meet your requirements.

1.Enter the data as you shared and create the measures to get the time values per way. Then we can get correct total and filter the table visual based on the rank.

Time value sub = SUM(Table1[Frq])*SELECTEDVALUE('Production Rate'[Production Rate])*SUM(Table1[Diff vs.subway])

Time value sub2 = SUMX(Table1,[Time value sub])

Time value train = SUM(Table1[Frq])*SELECTEDVALUE('Production Rate'[Production Rate])*SUM(Table1[Diff vs.Train])

Time value train2 = SUMX(Table1,[Time value train])

frqs = SUM(Table1[Frq])

rank = IF(ISBLANK([frqs]),BLANK(),RANKX(ALLSELECTED(Table1),[frqs],,DESC,Dense))

2.To get the total time that could be saved by selecting taxi. We can create the measure as below.

save time sub = SUM(Table1[Diff vs.subway])*SUM(Table1[Frq])

save time s = SUMX(Table1,[save time sub])

save time train = SUM(Table1[Diff vs.Train])*SUM(Table1[Frq])

save time t = SUMX(Table1,[save time train])

Here is the result for your reference.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/r81zv1xngb8qgo9/Incorrect%20Measure%20Total.pbix?dl=0

Regards,

Frank