Forum Discussion
Data status
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 ?
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()))
2 Replies
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()))
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.
