Forum Discussion

flintstone's avatar
flintstone
Icon for Helper II rankHelper II
5 years ago
Solved

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 d...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    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()))

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

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.