Forum Discussion
Solved
Creating percentage from a monthly report
Hi PowerBI Expert, A beginner here, I wanted to ask if I can create a percentage measure for approval with different measure. The measure that I use include gender, month and location. Year-Mo...
Hi,
The Year-Month field should come from the Calendar Table. There should be a relationship from the Date column of your Summary_los table to the Date column of your Calendar Table. Also, your measure can be simplified to:
total_register = COUNTA('summary_los'[decision])
count_approved =CALCULATE([total_register],'summary_los'[decision]="Approved")
Ashish_Mathur
Super User
Super UserHi,
The Year-Month field should come from the Calendar Table. There should be a relationship from the Date column of your Summary_los table to the Date column of your Calendar Table. Also, your measure can be simplified to:
total_register = COUNTA('summary_los'[decision])
count_approved =CALCULATE([total_register],'summary_los'[decision]="Approved")