Wrong amount of grand total TOP N function?

[bikelley]

Hello, 

Can anybody please tell me why my Top4 grand total is wrong? It should be 7488993, but now showing as 3659706. Because of this I will get the wrong answer on Grand total Cumulated MS, it should be HIGH as well. Please see below for my formal and sample attached file. I am confused. 

Top4 = CALCULATE(SUM(SuppliersBySegment[Total]), TOPN(4, SuppliersBySegment, SuppliersBySegment[Total], DESC))
SuppliersBySegment_Total = SUM(SuppliersBySegment[Total])
Test_% = [Top4]/[SuppliersBySegment_Total]

CUMULATED MS = 
VAR top4 = [Top4]/SuppliersBySegment[SuppliersBySegment_Total]
RETURN(
    IF (
        top4 >= 0.75, 
        "HIGH",
        IF (
            top4 >= 0.61,
            "MODERATE",
            IF(top4>0, "LOW", BLANK())
            )
        )
)

As you can see below Top4 should be 7488993 and Test_% should be 0.82 and CUMULATED MS should be HIGH 

Sample File- 

https://drive.google.com/file/d/1ZFVhy-pvMrs-GYkUq-310YFXNRjs0Kpu/view?usp=sharing 

Thank you so much

[bikelley]

@amitchandak  Thank you so much, second one wroks well. I appricate your help. 

[amitchandak · Accepted solution]

@bikelley , Try like

Top4 = CALCULATE(SUM(SuppliersBySegment[Total]), TOPN(4, SuppliersBySegment, SuppliersBySegment[Total], DESC), VALUES(SuppliersBySegment[market Segment]))

or Try like

CALCULATE(SUM(SuppliersBySegment[Total]), TOPN(4, ALLSELECTED(SuppliersBySegment[MarketSegment]), CALCULATE(sum(SuppliersBySegment[Total])), DESC),VALUES(SuppliersBySegment[MarketSegment]))

[bikelley]

@amitchandak  Tahnk you so much  for the quick reposnd, but it did not work. Still the same. Any other suggestions? 

[amitchandak]

@bikelley , check the attached file and see if that can help