Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Shaad_Khan
New Member

creating a clustered chart with different conditions

Hi,

I am new to Power BI, I am creating a clustered chart with where the data is to display based on Program name, the columns should show the Total registrations where attendee registered = "Yes" and Total attended where registrations="Yes" and "No".

The first condition is met but I am not able to display the total attended with the condition specified. It is taking the condition as yes for both columns. Please advise if anyone has a solution for this and how I can change this. 

Posting sample data below. 

 

Program NameAttendee RegisteredTotal RegisteredTotal Attended
PR1Yes153
PR1Yes155
PR1No03
PR1No01
PR1Yes154
PR1No00
PR2Yes107
PR2Yes104
PR2Yes105
PR2No01
PR2No07
PR2Yes107
PR2No03
PR2Yes105
1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @Shaad_Khan 

Try to create measures as below:

 

Total_registrations_registered_yes =
CALCULATE (
    SUM ( 'Table'[Total Registered] ),
    FILTER ( 'Table', 'Table'[Attendee Registered] = "Yes" )
)
Total attended_registrations_yes_no = 
CALCULATE (
    SUM ( 'Table'[Total Attended] ),
    FILTER (
        'Table',
        'Table'[Attendee Registered] = "Yes"
            || 'Table'[Attendee Registered] = "No"
    )
)

 

50.png

 

If  it doesn't meet your requirement,please share more details and your expected result.

 

Best Regards,
Community Support Team _ Eason

 

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

Hi, @Shaad_Khan 

Try to create measures as below:

 

Total_registrations_registered_yes =
CALCULATE (
    SUM ( 'Table'[Total Registered] ),
    FILTER ( 'Table', 'Table'[Attendee Registered] = "Yes" )
)
Total attended_registrations_yes_no = 
CALCULATE (
    SUM ( 'Table'[Total Attended] ),
    FILTER (
        'Table',
        'Table'[Attendee Registered] = "Yes"
            || 'Table'[Attendee Registered] = "No"
    )
)

 

50.png

 

If  it doesn't meet your requirement,please share more details and your expected result.

 

Best Regards,
Community Support Team _ Eason

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors