I am getting wrong sum in table visual:
Values and sum
In excel I am getting 0 in power BI 1839. So how to resolve this issue? I also used this measure:
sum_fix = IF(HASONEFILTER('N08-Klientai'[N08_PAV]),[day_range6],SUMX(VALUES('N08-Klientai'[N08_PAV]),[day_range6]))
And still total sum is wrong.
Hi @Analitika ,
Please try this measure.
'Table'[ColumnName],//If there are no rows or columns, please delete
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Watch this to fix incorrect total in measure.
How to fix Incorrect Measure Total in PowerBI | MiTutorials - YouTube
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.