Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@siva54 , Try like
new column =
var _1= calculate(distinctCOUNT([CATEGORY]), filter(Table, [product] = earlier([product])))
return
if(_1 >1 , "No", "Yes")
@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 .
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
43 | |
26 | |
21 |