Building grouped column graph to compare same data-column

[Anonymous]

Hi PowerBI experts!

I am attempting to build a grouped column graph, to compare the same data-column, but with different filters.

My data looks like this:

Company	Sales area	Result of call	Date
Company 1	Area 1	No answer	28-08-2018
Company 2	Area 1	Book meeting	28-08-2018
Company 2	Area 2	No interest	26-05-2018
Company 3	Area 3	Book meeting	25-04-2018

I need to compare:

AMOUNT calls FILTER "Book meeting" GROUPED BY Date

to
AMOUNT calls GROUPED BY Date

I know how to create the visualisation and how to filter the data, but i don't know how to filter one data series without the other?

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Please check the demo in the attachment. Create two measures like below.

AllCalls = COUNT(Table1[Result of call])

BookMeeting =
CALCULATE (
    COUNT ( Table1[Result of call] ),
    Table1[Result of call] = "Book meeting"
)

Best Regards,

Dale

[Anonymous]

AH thanks alot! to be honest i didn't attempt this because i was convinced it would not be able to group the measure by date for some reason.. 🙂 Every day is a school day!