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.  Seven of those slicers (the ones populated from tables along dimensions) are not actually filtering the table.  The table still lists all customers and just doesn't present the financial data for whatever isn't selected by the slicer.  The two slicers that are filtering the table are populated from customer categories found in the fact table itself.

It's a simple data model...one fact table and three dimensions.  All relationships are 1:M and single direction cross-filtering.

I've created other reports where slicers filter tables appropriately - meaning the only data shown is what is selected by the slicer.  I've looked around on here and Google in general and haven't seen anything like this.  Any insight anyone can provide would be appreciated!

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()
        )
    )

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Any chance you can upload some sample data? Onedrive work well

      • 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()
        )
    )