Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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]
)
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
49 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |