Forum Discussion

MxJ's avatar
MxJ
Frequent Visitor
7 years ago

Filter on certain filter category

Hi Guys,   I am using a table that shows YTD wholesale growth with the following DAX-query: Wholesale Growth = ([Total Wholesale]-Calculate([Total Wholesale];SAMEPERIODLASTYEAR(Real_date[Date])...
Need Help
MxJ's avatar
MxJ
Frequent Visitor
7 years ago

I have tried it but unfortunatly it does not work. It sets Q2, 3, 4 on zero but still uses jan, feb, mar for Q1 2018 and only jan for Q1 2019.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi MxJ,

 

Can you share a small sample? Please mask the sensitive parts first.

What's the formula of [Total Wholesale]?

 

Best Regards,

  • MxJ's avatar
    MxJ
    Frequent Visitor
    7 years ago



    On the left is my date table and on the right the wholesale table, the 2 are linked on Date = Sale_Date.

     

    The calculation for Total Wholesale

    Total Wholesale = calculate(sum('Wholesale'[Wholesale]);'Wholesale'[Segment]<>"3. Other")

    It sums the wholesale column and excludes one segment.

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi MxJ,

       

      Please download a demo from the attachment. All the date like fields should from the Real_Date table.

      Filter-on-certain-filter-category

       

       

      Best Regards,

      • MxJ's avatar
        MxJ
        Frequent Visitor
        7 years ago

        Thanks for your reply. 

         

        The only problem I have is that the formulas dont work when I use the real_date table is steady of the date from the wholesale table.. It returns "empty" when i use:

        Total Wholesale YTD = TOTALYTD([Total Wholesale];'Real_date'[Date]) 

        Also,  the figure from januari still does not show at Q1. 2019 gives -0,90 while januari gives 0,32 in your example.

         

        I need Q1 and 2019 to say 0,32 as well.