Hi How can i create a filter with YTD calculation of Ratio. For example :If i filter Coffee House , it will show YTD ratio of Coffee House only. If i filter Coffee House & Tea House, it will take the (sum of Rental / sum of Owned) of 2 houses to get the YTD ratio. Thank you CountryMonthRentalOwnedRatioCoffee HouseJan-19$42,331.00$324,762.0013%Tea HouseJan-19$1,352.00$37,591.004%Dessert HouseJan-19$4,764.00$169,344.003%Coffee HouseFeb-19$190,319.55$1,351,742.8414%Tea HouseFeb-19$3,084.00$134,903.312%Dessert HouseFeb-19$10,590.00$295,266.454%Coffee HouseMar-19$556,248.18$1,950,677.0029%Tea HouseMar-19$21,057.22$250,320.198%Dessert HouseMar-19$41,134.13$440,702.019%

Hi, You may download my PBI file from here. Hope this helps.

Helper V

6 years ago

Solved

Filter YTD calculation

How can i create a filter with YTD calculation of Ratio. For example :

If i filter Coffee House , it will show YTD ratio of Coffee House only.

If i filter Coffee House & Tea House, it will take the (sum of Rental / sum of Owned) of 2 houses to get the YTD ratio.

Thank you