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






Nandu_3033's avatar
Nandu_3033
Regular Visitor
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