Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello Everyone,
Here I'm again with doubts and errors 😞
In the following table the "Total" column is not adding well, as you can see for example Fishing is shown 90 instead of 97 which would be the correct result.
My formula is:
This table shows the differents ships that call at these ports
The sum of the rows is OK, the problem is adding the columns
.
Solved! Go to Solution.
Well @v-luwang-msft @amitchandak I found the solution
First, I rearranged the tables. Because one table contained several merges of others and from this super table the data was being extracted.
So, in this new arrangement with separable tables I applied this formula:
Well @v-luwang-msft @amitchandak I found the solution
First, I rearranged the tables. Because one table contained several merges of others and from this super table the data was being extracted.
So, in this new arrangement with separable tables I applied this formula:
Hi @Antonio_Gomez ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
Hi @Antonio_Gomez ,
Test the below,and if still not work ,could you pls share a sample data,and remember remove confidential data.
CantBuquesTotCorr =
IF (
HASONEVALUE ( V_HistoricalBbox[PUERTOS.PortNAME] ),
[CantBuquesTotales],
SUMX ( V_HistoricalBbox, [CantBuquesTotales] )
)
And refer:
https://archerpoint.com/how-to-make-measures-total-correctly-in-power-bi-tables/
https://community.powerbi.com/t5/Desktop/Wrong-column-totals-table/m-p/565904
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
@Antonio_Gomez , Ideally we should add column visual, add type and check
CantBuquesTotCorr = IF(
HASONEVALUE(V_HistoricalBbox[PUERTOS.PortNAME])
,[CantBuquesTotales]
,COUNTX(
Summarize(V_HistoricalBbox,V_HistoricalBbox[VesselId],V_HistoricalBbox[TYPE])
,[CantBuquesTotales]
)
)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |