Percent of filtered group

[Anonymous]

Hi Everyone!

Im glad to be joining your community as a new user (still newbie) on power BI! Time to leave excel dashboards behind.

Ive made some search on the forum looking for the solution i need but still couldnt figure it out.

On my data source i have many Product Codes grouped on Product families. I have the calculated "P1" percent column based on other two value columns.

Its working fine when calculating each of the codes %, but when i try to calc their  family, it sums instead of the % i need.

its family % should be:  9960/9200 = 108,26%

The formula im using on P1 column: 

P1 = DIVIDE(CALCULATE(SUM('Priorities (2)'[P1Done]),ALLSELECTED('Priorities (2)'[Product family])),(CALCULATE(SUM('Priorities (2)'[P1 FEB]),ALLSELECTED('Priorities (2)'[Product family]))),1)

Any help would be appreciated! Thanks!

[v-yuezhe-msft · Accepted solution]

@Anonymous ,

Based on your description, my understanding is that you want to  change the Total number of the P1 column from the sum (308.5% = 108.7%+100.0%+99.8%) to average (108.3%=9960/9200).

In this scenario, we can create a measure rather than a calculated column like below:

P1 = DIVIDE(CALCULATE(SUM(Table1[P1Done]),ALLSELECTED(Table1[Product family])),CALCULATE(SUM(Table1[P1 FEB]),ALLSELECTED(Table1[Product family])),1)

Here is a blog which discusses about this, I would suggest you referring to it: https://www.jetglobal.com/blog/calculated-columns-vs-measures/

Regards,
Lydia