Forum Discussion

Nandu_3033's avatar
Nandu_3033
Regular Visitor
2 years ago
Solved

Remove 0 values

  I want to filter out rows where all the selected columns have a value of 0. If even one of the selected columns has a non-zero value, the row should be displayed. also for eg if i just rem...
  • Nandu_3033's avatar
    Nandu_3033
    2 years ago
    this is the answer 
    Visual_Filter =
    VAR __SelectedValues =
        SELECTCOLUMNS (
            SUMMARIZE (
                'Values',
                'Values'[Parameter],
                'Values'[Parameter Fields]
            ),
            "Parameter", 'Values'[Parameter]
        )

     

    VAR NonZeroCheck =

     

        IF(
            SUMX(
                __SelectedValues,
                SWITCH(
                    [Parameter],
                    "Cost", IF([Cost] <> 0, 1, 0),
                    0  // Default if no match
                )
            ) > 0, 1, 0
        )

     

    RETURN NonZeroCheck






Ankur04's avatar
Ankur04
Resolver II
2 years ago

Hi, 

 

Create a measure which will take sum of all the columns you are going to add. and use that measure in filter for  your table visual and give the condition greater than 1.

 

Thanks,