Forum Discussion
Creating a calculated column
Hi Team
I'm new to power bi, need help to get the Result column.
Here the requirement is, Multiple Porducts can associated with only single Category.
For Example, {A=Fan,Pen}. Here Fan amd Pen is only for Category A. and they should not be used for Other categories
if Fan or pen used for Other categoreis then the result is "No".
Find the below picture for your reference.
Regards,
siva54
siva54 , Try like
new column =
var _1= calculate(distinctCOUNT([CATEGORY]), filter(Table, [product] = earlier([product])))
return
if(_1 >1 , "No", "Yes")
2 Replies
siva54 , Try like
new column =
var _1= calculate(distinctCOUNT([CATEGORY]), filter(Table, [product] = earlier([product])))
return
if(_1 >1 , "No", "Yes")Hi amitchandak Thanks for the solution. Need analyse cocd level also.
Here dax is
var _1= calculate(distinctCOUNT([CATEGORY]), filter(Table, [product] = earlier([product])))
return
if(_1 >1 , "No", "Yes")in that need to filter out with Cocd .
