Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |