Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    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"
    )
)

     

     

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

     

    Best Regards,
    Community Support Team _ Eason

     

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

    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"
    )
)

     

     

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

     

    Best Regards,
    Community Support Team _ Eason