Top & Bottom based on measure

[ismails]

Hi,

i am working with Top and Bottom data, FinalMarketUnit is measure. But when i used measure Bottom the data(FinalMarketUnit) is blank .

Bot3MarketUnit =
CALCULATE (
[FinalMarketUnit],
KEEPFILTERS(
TOPN (3, ALL( RegionMDMarketShare[MainDealerName]), [FinalMarketUnit],ASC )
))

When i tried into Bot 5, the data just 1 record. below is the result:

whats wrong with my measure? any body help me

Thanks

[v-yulgu-msft]

Hi @ismails,

I tested with above measure with some sample data on my side, it worked and returned result as expected. Please provide data of your source table and the formula of measure [FinalMarketUnit] for further analysis.

Best regards,

Yuliana Gu

[ismails]

hi @v-yulgu-msft,

When i tried the measure with another sample data it works.. i think the problem is with my measure and relationship.

Below i share the file pbi https://drive.google.com/open?id=1BfKlB1c5UTQc9K98PxYVx5ZSNuYCli5u

Hopefully u can give me the solutions..

Thank you

Regards,

ismails