How to make my table display all Brand ? now only display 1 Brand

[admin11]

Hi All

My SALES table have field name = BRAND_C

i Have create a SliceTable also have BRAND_C

I also create a expression to link the SliceTable to BRAND_C

_Select_measure =

var _select=SELECTEDVALUE(SliceTable[Slice])

return

SWITCH(

TRUE(),

_select="BRAND_C", MAX('summrizeTable1'[BRAND_C]),

_select="CUST_ID", MAX('summrizetable2'[CUST_ID]))

But when i select Slice = BRAND_C

Table not display all BRAND name , only display 1 BRAND ONLY 

my very small PBI file :-

https://www.dropbox.com/s/jo1v2o83ib6sm8f/SAMPLE_1000_SI_TI_V010.pbix?dl=0

Paul

[v-angzheng-msft]

Hi, @admin11 

The link above is not accessible.

It makes it easier to give you a solution.

1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11]

@v-angzheng-msft 

Thank you very much for look into my post.

I have create a new post below :-

https://community.powerbi.com/t5/Desktop/Dynamic-dimension-only-work-for-Brand-but-not-Segment/td-p/...

In above post i have provide 2 link , one is the PBI file did by you which is working fine. Another link which is create by me with sample data only 100 row. which is not working. you can access the link below directly :-

https://www.dropbox.com/s/g75b3te1tldthvv/NOT%20WORKING.pbix?dl=0

Once you can high light to me where i go wrong , i should be able to fully understand , and i should be able to solve my problem.

Paul Yeo

[admin11]

Hi All

i have try to create a rank column :-

rank = RANKX('summrizeTable1','summrizeTable1'[sum],,DESC)

it still display only last row.

[VahidDM]

@admin11 

Van you share your file on:

https://wetransfer.com/

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