Same expression Sales Contribution % work in Coy Table but not Segment Table ?

[admin11]

Hi All

i have below expression working fine when i use with customer name  :-

Sales Cont % = DIVIDE('SALES'[SALES_],CALCULATE('SALES'[SALES_],ALLSELECTED('SALES')))

But same expression when i use with SEGMENT_C , it display all 100% :-

My PBI file :-

https://www.dropbox.com/s/x2uo440ln2vk37d/SUPPLIER%20SALES%20CONTRIBUTION%20final.pbix?dl=0

Paul

[amitchandak]

@admin11 , is there a join between Table 1 and Table 2

Means is Segment_C is joined with the table having column for sales_ measure

[admin11]

@amitchandak 

Table 1 and 2 are join. 

i can get it work for sales by customer name , sales by staff , sales by year. for sales contribution % , but when i try segment_c it does not work.

[v-stephen-msft]

Hi @admin11 ,

The pbix file you provided has been deleted. Can you provide it again?

Best Regards,

Stephen Tao

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