Calculate Percentage of Dimensions

[marcushart12]

I am working with a table that has 24k unique dimension sizes. There are filters on the page that will reduce this number pending the filter on the page. From the distinct dimesion sizes, I am trying to get the total % of those to populate and equal 100%

For example, on a page that has State = Florida as the page filter.

I want to see a list of those dimensions that has a sort of 1 by % that will also total to 100%.

The dimesion field  in power bi is a text and Sort is Whole Number

I got it working for another table using this forumla 

% of Dimensions = DIVIDE(CALCULATE(Count('Missorts Data'[Dimensions])), CALCULATE(SUM('Missorts Data'[Missorts]), ALLSELECTED('Missorts Data')))

However, for our other datset, when we use the measure of

% of Dimensions II = DIVIDE(CALCULATE(Count('Power BI - All Bags'[Dimensions])), CALCULATE(SUM('Power BI - All Bags'[Missorts]), ALLSELECTED('Power BI - All Bags')))

The table shows as below.. The 6350 should be divided by the total of 197392

[marcushart12]

Please disregard this post. I was able to figure it out and it is working now. Thank You

[marcushart12]

ID Number	Dimensions	Sort	Vol
273862330470	14.00x    10.00x     1.00	0	1
273744406443	11.00x     9.00x     1.00	1	1
272962515736	1.00x     1.00x     1.00	0	1
273082718583	12.00x     9.00x     2.00	1	1
776038451205	33.00x    28.00x    10.00	1	1
273114557665	11.00x     7.00x     3.00	0	1
273828316070	11.00x    10.00x     2.00	0	1
618668263001	15.00x    10.00x     2.00	1	1
273490417165	10.00x    10.00x    10.00	0	1
707673697759	12.00x     9.00x     1.00	1	1
712750473882	8.00x     6.00x     1.00	0	1
796802518966	18.00x    13.00x     3.00	0	1
737648244208	14.00x    11.00x     4.00	1	1
737169899396	13.00x     6.00x     2.00	0	1
273876517669	6.00x     1.00x     1.00	0	1

[marcushart12]

Sample data is attached. Thank You @lbendlin . I am new to Power BI and this platform but catching on pretty fast.

[lbendlin · Accepted solution]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...