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,
i have a problem to get a correct sum of percentages for my project. I will show in details below;
I have a column named section as u can see in the image. Then i try to group this section like in another image below;
I also have a measure for YDA (yesterday),
Solved! Go to Solution.
Hi @New_be ,
Change your %Total Reject Measure to this.
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
@New_be , to me this seems correct formula, Can you put the [TOTAL_REJECT] and [TOTAL_PRD] next to REJECT_YDA. Because one of them might have subtotal issue
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
https://www.youtube.com/watch?v=AJxCCfFmLTQ
i try to follow like in this video. But seems like i make some mistake. Below is my code;
My code:
HI @New_be,
Can you please share a part of dummy data with a similar data structure and expected result? It will help to test coding formula on it. How to Get Your Question Answered Quickly
In addition, you can also take a look at the following link about measure total calculations if it meets your requirement:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
Hi @New_be ,
Change your %Total Reject Measure to this.
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
@harshnathani Whit if i use a TOTALYTD function? can it also be calculate like that?
Here is my YTD calculation;
Hi, can i get your email for me to send u a dummy data?
@New_be , I see most of the values wrong as divide has some extra filter na relation.
Check with these two measures
CALCULATE( [TOTAL_REJECT] ,
USERELATIONSHIP( 'Calendar'[DATE], RRB[Date (7-7)] ), 'Calendar'[Yesterday Equal Today] = TRUE() )
CALCULATE([TOTAL_PRD] ,
USERELATIONSHIP( 'Calendar'[DATE], RRB[Date (7-7)] ), 'Calendar'[Yesterday Equal Today] = TRUE() )
Hi Mr. Amitchandak,
can i get your email to send u a small dummy data in ppbix?
Here the values. But sum of percentages does not sum like the actual sum. For example, TOTAL BLOCK AB should get 0.05% instead of 0.03%
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |