Forum Discussion

littlemojopuppy's avatar
littlemojopuppy
Community Champion
7 years ago
Solved

Slicers Not Filtering?

Hi!  I have a question about something weird I'm hoping someone could give me some insight in why...   I have a table populated with customer names along with some financial info and nine slicers. ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    In some of the measures you are checking to see if should have a value, just need to change that from 0 to BLANK()

     

    Contribution Margin Per Case = 
    IF(
        SUM('Raw Data'[Volume]) = blank(),
        BLANK(),
        DIVIDE(
            SUM('Raw Data'[Contribution Margin]),
            SUM('Raw Data'[Volume]),
            BLANK()
        )
    )

Net TGP Per Case = 
    IF(
        SUM('Raw Data'[Volume]) <= 0,
        BLANK(),
        DIVIDE(
            SUM('Raw Data'[Net TGP]),
            SUM('Raw Data'[Volume]),
            BLANK()
        )
    )

Contribution Margin Rate = 
    IF(
        SUM('Raw Data'[Net Sales]) <= 0,
        BLANK(),
        DIVIDE(
            SUM('Raw Data'[Contribution Margin]),
            SUM('Raw Data'[Net Sales]),
            BLANK()
        )
    )

littlemojopuppy's avatar
littlemojopuppy
Community Champion
7 years ago

Hi!  You should be able to download the PBIX file from here

Anonymous's avatar
Anonymous
Not applicable
7 years ago

In some of the measures you are checking to see if should have a value, just need to change that from 0 to BLANK()

 

Contribution Margin Per Case = 
    IF(
        SUM('Raw Data'[Volume]) = blank(),
        BLANK(),
        DIVIDE(
            SUM('Raw Data'[Contribution Margin]),
            SUM('Raw Data'[Volume]),
            BLANK()
        )
    )

Net TGP Per Case = 
    IF(
        SUM('Raw Data'[Volume]) <= 0,
        BLANK(),
        DIVIDE(
            SUM('Raw Data'[Net TGP]),
            SUM('Raw Data'[Volume]),
            BLANK()
        )
    )

Contribution Margin Rate = 
    IF(
        SUM('Raw Data'[Net Sales]) <= 0,
        BLANK(),
        DIVIDE(
            SUM('Raw Data'[Contribution Margin]),
            SUM('Raw Data'[Net Sales]),
            BLANK()
        )
    )