Forum Discussion

pezakas's avatar
pezakas
Icon for Helper I rankHelper I
3 years ago

Showing data while dataset is filtered

Hello community, This is my dataset.  The user always picks a date from a single selection slicer, that is using the "Dataflow_Date". I would like to create a measure so that when user sel...
Need Help
Tips and Tricks
NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
3 years ago

Hello pezakas 

Your question is bit confusing. You want sum of effort of previous year when user selects 31/1. That would look like below in a table visual. What would you want to see when user selects 28/2?

 

31/1 selected:

Project IDEffort(MDs)Dataflow_Date
ID0011231/01/2023(sum of effort of 2022)
  • pezakas's avatar
    pezakas
    Icon for Helper I rankHelper I
    3 years ago

    When user selects 28/02 , he should see the effort as of 31/01 of the same year.

    • NaveenGandhi's avatar
      NaveenGandhi
      Icon for Memorable Member rankMemorable Member
      3 years ago
       
      pezakas 

      Try the below measure.

      Effort PRevious =
      VAR Prev_=
      IF (
      MONTH ( MAX ( Effort[Dataflow_Date] ) ) = 1,
      CALCULATE (
      SUM ( Effort[Effort(MDs)] ),
      ALL ( Effort ),
      PREVIOUSYEAR ( Effort[Dataflow_Date] )
      ),
      CALCULATE (
      SUM ( Effort[Effort(MDs)] ),
      PREVIOUSMONTH ( Effort[Dataflow_Date] )
      )
      )
      RETURN
      Prev_

       

      Let me know if this helps.

       

      Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!




       
      • pezakas's avatar
        pezakas
        Icon for Helper I rankHelper I
        3 years ago

        Does this work if you select the January from date slicer? Or it returns blank()?
        When you set ALL(Effort) it means you clear the whole table from filters , right?