Forum Discussion

Yashh's avatar
Yashh
Icon for Helper II rankHelper II
3 years ago
Solved

Filter according to Revision number

Hello all, I have this code and I am getting the correct data. Just I have to put one more filter where i have a column called Source Name which will allow me to see the new added matier...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Yashh ,

    You can filter directly into CountRows

    Custom rule [Source Name]<2

    Here are the steps you can follow：

    1. Create calculated column.

    Duplicates = 
var varCurrentValue=
'MD4C-Multi'[Material]
var varInstances=
COUNTROWS(
    FILTER('MD4C-Multi','MD4C-Multi'[Material]= varCurrentValue&&'MD4C-Multi'[Source Name]<=2))
var  Result=
IF(
    varInstances >1,"Duplicate","Unique")
return
Result

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Yashh ,

You can filter directly into CountRows

Custom rule [Source Name]<2

Here are the steps you can follow：

1. Create calculated column.

Duplicates = 
var varCurrentValue=
'MD4C-Multi'[Material]
var varInstances=
COUNTROWS(
    FILTER('MD4C-Multi','MD4C-Multi'[Material]= varCurrentValue&&'MD4C-Multi'[Source Name]<=2))
var  Result=
IF(
    varInstances >1,"Duplicate","Unique")
return
Result

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly