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.
Hey guys! I'm recently facing an issue regarding a SUM measure.
I have this dataset in Excel and I want to see the sum by category, as follows (these are the right numbers)
On Power Bi, I did a simples measure "_Sum = sum(mainBase[Paid_Price_Ajust])", but it doesn't seem to work properly. The grand total is right, so is some categories, but 2 of them are not ("Midia Paga" and "Organico"), as follows:
My expected result would be the same numbers from the Excel file. I thought it could be some error importing the base, but when I tried creating a summarize table it worked fine, so I'm out of options (Summarize table below, working properly)
Would appreciate any help!
Solved! Go to Solution.
@juniorBI , Please check excel data is loaded properly. Last time I saw such an issue. there was a data type issue or join issue
@juniorBI , Please check excel data is loaded properly. Last time I saw such an issue. there was a data type issue or join issue
I figured it out, there was a problem in the relationships, part of the data was duplicated in another sheet. 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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |