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

Question

Hi All&nbsp;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])))&nbsp;Today it return every row same amount , which is wrong .&nbsp;May i know how to trouble and modify the expression , so that it will return correctly ?&nbsp;My PBI file :-https://www.dropbox.com/s/sw43007uq39ylk6/SAMPLE_1000_SI_TI_V019.pbix?dl=0&nbsp;Paul Yeo

anonymous · Answer

Hi&nbsp;admin11&nbsp;,
&nbsp;

&nbsp;
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.&nbsp;More people will benefit from it.&nbsp;
&nbsp;
Best Regards,Eyelyn Qin

vahiddm · Answer

HI&nbsp;admin11&nbsp;&nbsp;Can you upload your file on&nbsp;https://wetransfer.com/&nbsp;and share the link&nbsp;Appreciate your Kudos!!LinkedIn:&nbsp;www.linkedin.com/in/vahid-dm/&nbsp;&nbsp;

admin11 · Answer

VahidDM&nbsp;Thank you for sharing :-&nbsp;My sample doc :-https://www.dropbox.com/s/pktxk2ih2n6yfhs/SAMPLE_1000_SI_TI_V021.pbix?dl=0&nbsp;Paul&nbsp;

ashish_mathur · Answer

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

admin11 · Answer

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

Forum Discussion

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

8 Replies

Related content

Help!!! Expression Error

Regular expression

LASTNONBLANK when expression only returns blank

Calendar Table returning error: The expression specified in the query is not a valid expression

Regular Expression Functions (REGEX) in Power Query