Forum Discussion
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...
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()))
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()))