Data status

[flintstone]

In SPSS, there is a function to show the number of missing data, total data and % missing data /total data. Is there a way to do this in Power bi and also to show for duplicate data and % duplicate data/total data ?

[v-henryk-mstf]

Hi @flintstone ,

I did a test and think that the formula provided by @amitchandak  is feasible.

If the problem is still not resolved, please provide detailed error information and a screenshot of the desired result, I will answer for you as soon as possible. Looking forward to your reply.🙂

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@flintstone , duplicate date %

divide(count(Table[Column]) - countdistinct(Table[Column]), count(Table[Column]))

Missing value need context like item missing in fact

if(isblank([measure]),1,0)

plot against any dimension it will give missing value

or try like

countx(values(item[item]),if(isblank([measure]),[item],blank()))