How to modify my expression , so that it will not return every row same value ?

[admin11]

Hi All

I have below expression working fine in the past :-

_amount_select2 =

SWITCH(

SELECTEDVALUE(SliceTable[SLice]),

"BRAND_C",IF(ISINSCOPE(summrizeTable3[rank]),

CALCULATE(SUM('SALES'[sales]),FILTER(ALLSELECTED('SALES'),[BRAND_C]=MAX('summrizeTable2'[BRAND_C]))),

SUM('SALES'[sales])))

Today it return every row same amount , which is wrong .

May i know how to trouble and modify the expression , so that it will return correctly ?

My PBI file :-

https://www.dropbox.com/s/sw43007uq39ylk6/SAMPLE_1000_SI_TI_V019.pbix?dl=0

Paul Yeo

[Anonymous]

Hi @admin11 ,

The file you uploaded before has been deleted, so if you are still confused about it, please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data.

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @admin11 ,

Glad to know your issue has been solved !😀

Could you please knidly share the solution and then Accept it as the solution to make the thread closed. More people will benefit from it. 

Best Regards,
Eyelyn Qin

[admin11]

@Anonymous 

sorry that i just found the answer is not fully correct. so need to wait.

[VahidDM]

HI @admin11 

Can you upload your file on https://wetransfer.com/ and share the link

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[admin11]

@VahidDM 

Thank you for sharing , i already found the issue. 

Now working fine.

Paul

[admin11]

@VahidDM 

Thank you for sharing :-

My sample doc :-

https://www.dropbox.com/s/pktxk2ih2n6yfhs/SAMPLE_1000_SI_TI_V021.pbix?dl=0

Paul

[Ashish_Mathur]

Hi,

There is no file there.  Also, please describe the question in simple English.  What are you trying to do/accomplish?

[admin11]

Hello my PBI master @Ashish_Mathur , thank you for looking into my post . i manage to found the issue and now working fine.

Paul