Forum Discussion

Iamrajj's avatar
Iamrajj
Frequent Visitor
3 years ago

Filter not working in DAX

Bandp_Cta TI = CALCULATE(SUM(bnp_cta]),DATESBETWEEN(date,startdate,enddate),ALL(nameplate))
 

 required output

 

 

Need Help

2 Replies

  • danextian's avatar
    danextian
    Super User
    3 years ago

    Hi Iamrajj ,

     

    Please provide more context to your post. What exactly is not filtering? Which one is your desired output? bnp_cta from nameplate table, etc? Also, please provide a sample data we  can easily work on, can be copy-pasted (not an image).

    • Iamrajj's avatar
      Iamrajj
      Frequent Visitor
      3 years ago

      I need to show slicer last month, last week, and YTD dynamic selection.

      Created measure for start date and end date for all time intelligence

       

      Bandp_Cta TI = CALCULATE(SUM(bnp_cta]),DATESBETWEEN(date,startdate,enddate),ALL(nameplate))

       

      nameplateBandp_Cta TI
      Brand Level (Feb23-May23)8869
      Challenger8936
      Charger8936
      Durango8936

      Total                                  8936

       

      but iam getting total value istead of nameplate breakup.

       

      Output required

       

      nameplateBandp_Cta TI
      Brand Level (Feb23-May23)6968
      Challenger553
      Charger976
      Durango439
      Total8936