Forum Discussion

katto16's avatar
katto16
Icon for Helper I rankHelper I
3 years ago

Count if values from three different columns are unique

Hi. I'm pretty new to Power BI and recently learned how to do Distinct Counts, Calculate, basic DAX etc. I have this thing I'm trying to solve which I have done in Excel but would like to compile all...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

katto16 , A new column

=

var _1 = countx(filter(Table, [Unit ID] = earlier([Unit ID]) ), [Unit ID)

var _2 = countx(filter(Table, [Unit ID] = earlier([Actuato rID]) ), [Actuator ID)

var _3 = countx(filter(Table, [Unit ID] = earlier([Module ID]) ), [Module ID)

var _4 = countx(filter(Table, [Unit ID] = earlier([PWA ID]) ), [PWA ID)

return

if(_1+_2+_3+_4+0 >0, 0, 1)

katto16's avatar
katto16
Icon for Helper I rankHelper I
3 years ago

Hi amitchandak 

Thank you very much for your help. I can't seem to create a variable after the first one. 

This is the error code.