Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

keeping fixed values

i need to find the percentage diffrence between No_Visit and Completed_Visits as (completed visits / total No_visits). No_visit is total of year 2020 and it shoulld be fixed. completed visit should b...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous，

    Regarding this post, did you get the results you wanted? If so, could you please mark the helpful post as Answered? This will also help others in the community if they are having the same problem as you. Thank you.

    Best Regards

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , with help from date table complete year value

 

This Year = CALCULATE(sum('Table'[No_visit]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))

 

This year Sales = CALCULATE(sum('Table'[No_visit]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))

 

Force only 2020

This Year = CALCULATE(sum('Table'[No_visit]),filter(ALL('Date'),'Date'[Year]=2020 ))

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    im getting the value as infinity 

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      4 years ago

      Anonymous , what formula you have used and what you got in denominator

       

      Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.