How to merge three different columns ?

[Anonymous]

Hi everyone,

I would like to know if its possible to put these three differents charts into one chart. Each chart has the same value (Minutes) and dimension (WaitingRoom) different filter:

• first chart (dark green) is based on filter      'is less than or equal to zero'
• second chart (light green) is based on filter   'is greater than or equal to zero and is less than or equal to 20'
• third chart (red) is based on filter 'is greater than 20'

Any suggestions? thanks in advances.

[vanessafvg · Accepted solution]

@Anonymous create separate measures for each

ie

measure 1(dark green) = calculate(sum(measure), column <= 0)

etc.

and then plot them each on teh same graph

[Anonymous]

@vanessafvg Thanks for your answer!

How to write a measure with this filter condition  'is greater than or equal to zero and is less than or equal to 20'?

Is this correct?

Measure= CALCULATE([TotalExaminationProcessInsight];
    'Fact ProcessInsights'[Duration] >= 0;
     'Fact ProcessInsights'[Duration] <= 20 )

[vanessafvg]

@Anonymous looks correct have you tested it?