Export to csv shown wrong total.

[Yagevendra]

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.

[v-jayw-msft]

Hi @Yagevendra ,

It's better to share some sample data if you don't have any Confidential Information.

I did some simple test but could not reproduce the scenario.

Best Regards,

Jay

[Yagevendra]

Hi @v-jayw-msft 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

[v-jayw-msft]

Hi @Yagevendra ,

I didn't get the point. Shouldn't the total result be 10? Do you want it to be 30?

Best Regards,

Jay

[Yagevendra]

@v-jayw-msft i know it should be 30 because each row of table has group of same values and unique_HH is distinct count of this particular group but if you can see on line chart the total of 10 by date and the client requirment is  should be 10 on export not 30..
I know client requirment may be wrong becasue line chart shown distint count on date wise only and table shown distinct count based on group of values.

[v-jayw-msft]

Hi @Yagevendra ,

The total of a measure is a calculated value returned by the formula. It's not a simple cumulative value of the measure.

Best Regards,

Jay

[parry2k]

@Yagevendra can you share the pbix file, remove sensitive information before sharing.

[Yagevendra]

Hi @parry2k There is no option available to attech PBIX file how could i provide file here any other way?

[parry2k]

@Yagevendra 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.⚡

[Yagevendra]

@parry2k 

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:-

[Yagevendra]

@parry2k 
I tried this dax formula the total of table changed 2022 to 5705

Unique 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]))

return

SUMX(_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.