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 all,
I have an issue when trying to calculate a total between a range of accounts (Total sales, Sum accounts between 1001-1900 etc).
I have created below measure:
GL amount = SUMX(Kontoplan;
IF( NOT ISBLANK(Kontoplan[Totaling.2]);
CALCULATE ( SUM(Finansposter[Realized, Amount]);
FILTER(ALL(Kontoplan); Kontoplan[No_] > EARLIER(Kontoplan[Totaling.1]) && Kontoplan[No_] < EARLIER(Kontoplan[Totaling.2])) );
CALCULATE ( SUM(Finansposter[Realized, Amount]) ))
)
The amounts are korrect for each individual account, but it is not correct on the Total accounts, which is a Sum between the range in Totaling 1 and Totaling 2. I guess it also calculates the Sub Total accounts, when calculating the Total.
Can anyone assist here?
Hi @Anonymous,
I have tested the data you post in the problem and I could get the correct sum like the picture below. I could not find the sub total data you mentioned in your problem, could you please offer more information about the structure of your data or could you share pbix file if possible? If the report does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.
Regards,
Daniel He
Hi Daniel,
Appreciate your time and respond, I will make a demo file tonight/tomorrow and send it to you - thanks!
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |