Forum Discussion

Tito's avatar
Tito
Helper IV
1 year ago
Solved

Add filter

Hello everyone, I need a filter to see the names which their number is greater than 1. If the sum of the number is empty or equal to 1, then " empty or equal to 1" otherwise "greater than 1"   Ra...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Tito 

    Assuming your definition of number is the  count of records per name, create this calculated column.

    Slicer Column =
VAR _CountPerName =
    CALCULATE ( COUNTROWS ( 'table' ), ALLEXCEPT ( 'table', 'table'[name] ) )
RETURN
    IF ( _CountPerName > 1, "greater than 1", "Empty or equal to 1" )
danextian's avatar
danextian
Super User
1 year ago

Hi Tito 

Assuming your definition of number is the  count of records per name, create this calculated column.

Slicer Column =
VAR _CountPerName =
    CALCULATE ( COUNTROWS ( 'table' ), ALLEXCEPT ( 'table', 'table'[name] ) )
RETURN
    IF ( _CountPerName > 1, "greater than 1", "Empty or equal to 1" )
  • Tito's avatar
    Tito
    Helper IV
    1 year ago

    Hi danextian ,

     

    Thank you very much. I have adjusted your measure:

    Slicer Column =
VAR _CountPerName =
    CALCULATE ( DISTINCTCOUNT( 'table' ), ALLEXCEPT ( 'table', 'table'[name] ) )
RETURN
    IF ( _CountPerName > 1, "greater than 1", "Empty or equal to 1" )