Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Urgent Help---Filter issues

Hi Everyone,

   I created one calender table by using start date and end date in that table I created columns for fiscal years.

  Then  I created a two measures for  min of start date and max of end date in my original table.

  The measures are

  FMinimum date = CALCULATE(MIN('Test'[startdate]),ALLSELECTED('Test'[startdate]))
  FMaximum date = CALCULATE(MAX('Test'[enddate]),ALLSELECTED('Test'[enddate]))

  But my issue is I used the slicer of fiscal column it shows the FMinimum date and FMaximum date for all the year. I want to show filtered FMinimum date and FMaximum date belong to filtered fiscal years only.  I created financial year column for 1 april to 31 march . I used this filter to show the maximum and minimum dates of records It shows the all the records with null values. I attach my screenshot and pbix for your reference.

Kindly check this pbix file for your reference. Help me as soon as possible..

https://1drv.ms/u/s!Aoy7ZnpipsSQa_GXKAEM3xBCBRo?e=cQ518k

Thank you

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak 

          Thanks for your reply. I changed my measure based upon your suggestion but no changes appeared in that measure. The issue is also not solved. Kindly check my attached screenshot and help me on this issue.

       

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        6 years ago

        Hi , Anonymous 

        Is this the expected result want?

         

        try measures as below:

        MaxDate of selectedFY = 
var selectedFY=SELECTEDVALUE('Calendar date'[Financial Year])
RETURN CALCULATE(MAX('Calendar date'[Date]),'Calendar date'[Financial Year]=selectedFY)
        MinDate of selectedFY = 
var selectedFY=SELECTEDVALUE('Calendar date'[Financial Year])
RETURN CALCULATE(MIN('Calendar date'[Date]),'Calendar date'[Financial Year]=selectedFY)

        pbix attached

         

        Best Regards,
        Community Support Team _ Eason
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.