Forum Discussion
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...
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
Hi Anonymous ,
I created a sample pbix file(see attachment), please check whether that is what you want. You can create a measure as below:
percentage diffrence =
VAR _nvisits =
CALCULATE ( SUM ( 'Table'[No_Visit] ), ALL ( 'Table' ) )
VAR _cvisits =
CALCULATE ( SUM ( 'Table'[Completed visit] ) )
RETURN
DIVIDE ( _cvisits, _nvisits, 0 )
Best Regards
thank you
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