Forum Discussion
How to merge three different columns ?
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.
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
3 Replies
- vanessafvg
Community Champion
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
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?