Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to 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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |