cancel
Showing results for 
Search instead for 
Did you mean: 
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

 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors