Forum Discussion
Export to csv shown wrong total.
Hi all,
When i export my visual data into csv file the total of value column showing me wrong i had created measure = Distinctcount(Homenumber)
I was trying to convert visual into table and find out the solution but didn't get anything i found only my table total haven't match with my data.
I know something i did wrong with measure but i create simple measure distinct count.
I faced same problem with other visual and those visual have complax dax.
Need help.
10 Replies
Anonymous there are many posts talking about it, here is a similar one, if it still doesn't work, share the sample data and how you are visualizing it.
Solved: COUNT DISTINCT SHOWS WRONG GRAND TOTAL - Microsoft Power BI Community
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
The total of Unique house is correct 2022 but the value inside the table is not correct, while i exporting data into csv then the total of unique house column changed to 5705 exact match with table insides value.
Here are the values shown in export file:-parry2k
I tried this dax formula the total of table changed 2022 to 5705Unique House = var _t = SUMMARIZE(F_20210716,F_20210716[Date],F_20210716[E_ID],F_20210716[Region],F_20210716[Home number],F_20210716[Installation Status],"UniqueHome",DISTINCTCOUNT(F_20210716[Home number]))returnSUMX(_t,[UniqueHome])But i didn't get my expacted answer
Also i filterd my data table it shown me the distinct count is 2022 this is correct value. i don't know why on table and export shown me wrong output.
Anonymous can you share the pbix file, remove sensitive information before sharing.
Hi parry2k There is no option available to attech PBIX file how could i provide file here any other way?
Hi Anonymous here is the sample data.
Date E_ID Region Home number Status 6/21/2021 650 North 6 RH 6/21/2021 3 East 6 RH 6/21/2021 1 West 6 RH 6/21/2021 650 North 14 RH 6/21/2021 2 South 14 RH 6/21/2021 1 West 14 RH 6/21/2021 650 North 20 RH 6/21/2021 2 South 20 RH 6/21/2021 1 West 20 RH 6/21/2021 650 North 35 RH 6/21/2021 2 South 35 RH 6/21/2021 1 West 35 RH 6/21/2021 650 North 38 RH 6/21/2021 2 South 38 RH 6/21/2021 1 West 38 RH 6/21/2021 650 North 39 RH 6/21/2021 2 South 39 RH 6/21/2021 1 West 39 RH 6/21/2021 650 North 46 RH 6/21/2021 2 South 46 RH 6/21/2021 1 West 46 RH 6/21/2021 650 North 49 RH 6/21/2021 2 South 49 RH 6/21/2021 1 West 49 RH 6/21/2021 650 North 53 RH 6/21/2021 2 South 53 RH 6/21/2021 1 West 53 RH 6/21/2021 650 North 60 RH 6/21/2021 2 South 60 RH 6/21/2021 1 West 60 RH
