Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
g_f
Regular Visitor

DISTRIBUTE A VALUE ACROSS MULTIPLE VALUES

GOOD EVENING, I HAVE A TABLE OF SKU OF WHICH I HAVE SALES. ON THESE SALES. I CALCULATED WITH THE DAX THE PERCENTAGE SHARE.TO THESE VALUES I HAVE TO ADD A NATIONAL VALUE ( DISTINCT PER SKU) TO DISTRIBUTE AND ADD TO THE CURRENT VALUES. I CAN'T. CAN ANYONE HELP ME?

 

EXAMPLE : 

 

 ROMA MILANOTORINOTOTAL ROMA MILANOTORINOTOTAL
SKU_196733172 56%42%2%100%
SKU_2372465126 29%19%52%100%
SKU_3976361221 44%29%28%100%
SKU_4864685217 40%21%39%100%
SKU_540777124 32%6%62%100%
SKU_6966927192 50%36%14%100%
SKU_799693171 58%40%2%100%
SKU_82811746 61%24%15%100%
SKU_975945129 58%7%35%100%
SKU_10729095257 28%35%37%100%
SKU_11784696220 35%21%44%100%
SKU_1235293599 35%29%35%100%
SKU_1355686147 37%4%59%100%
SKU_14971788202 48%8%44%100%
          
 NAZIONALE       
SKU_1150        
SKU_2200        
SKU_3118        
SKU_4122        
SKU_5104        
SKU_6125        
SKU_7119        
SKU_8119        
SKU_9119        
SKU_10141        
SKU_11139        
SKU_12119        
SKU_13109        
SKU_14143        
1 REPLY 1
lbendlin
Super User
Super User

Do you need to distribute the national numbers across the three cities according to their weight?  Does it need to result in integer numbers or are fractions acceptable?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.