topic Re: Creating a calculated column in DAX Commands and Tips

Creating a calculated column

siva54 — Fri, 17 Sep 2021 09:51:38 GMT

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

Re: Creating a calculated column

amitchandak — Fri, 17 Sep 2021 10:56:38 GMT

siva54 , Try like

new column =
var _1= calculate(distinctCOUNT([CATEGORY]), filter(Table, [product] = earlier([product])))
return
if(_1 >1 , "No", "Yes")

Re: Creating a calculated column

siva54 — Fri, 22 Oct 2021 04:50:51 GMT

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 .