Forum Discussion

GrahamR99's avatar
GrahamR99
Icon for Resolver I rankResolver I
6 years ago
Solved

Slicer not filtering on Measure

Hello

I have a Slicer that filters on Area, it works fine on my matrix, but when I put a Measure on my matrix I get the shops that my slicer is filtering and I also get all the other shops with the measure at 100%.

 

Why does my slicer not filter on the Measure?

 

Here is the code for the Measure.

P_Year_Difference = CALCULATE(DIVIDE(SUM(CT_Query[Total_Gross_Paid]), Sum(CT_Query[CT_Query_LastYear.Total_Gross_Paid]) )-1)
 
Regards
 
GrahamR99
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi GrahamR99 ,

    It is caused by minus 1 while calculating increased percentage. Please try to drag the column "Shops" which is from the table "Shops" into the table.

    Please see the attachment below.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

    • GrahamR99's avatar
      GrahamR99
      Icon for Resolver I rankResolver I
      6 years ago

      Hello amitchandak

      What is a doubt join?

       

      There is no relationship between the two tables as I have a thrid table which is a list of shops which has a relationship to both tables and blocks me from creating a relationship between the two tables.

       

      The only line is a merge and that is a full outer join.

       

      Regards

       

      GrahamR99       

      • v-xuding-msft's avatar
        v-xuding-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi GrahamR99 ,

        It is caused by minus 1 while calculating increased percentage. Please try to drag the column "Shops" which is from the table "Shops" into the table.

        Please see the attachment below.

         

        Best Regards,

        Xue Ding

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.