Forum Discussion
Solved
cumulative bar graph
I have the following Graph but I want to create a cumulative graph of the previous graph. I create the following code Acomulado RCA =
CALCULATE(
COUNTA('Reporte'[Etiqueta]);
FILTER(
CA...
hi, rodfernandez
You could try this way:
Step1:
Create a fact Mes table, then create the relationship with report table by Mes
Step2:
Use this formula to add a measure
Acomulado RCA = CALCULATE ( COUNTA ( 'Reporte'[Etiqueta] ), FILTER ( ALLSELECTED ( Mes ), ISONORAFTER ( 'Mes'[Mes], MAX ( 'Mes'[Mes] ), DESC ) ) )Result:
and here is my sample pbix file, please try it.
Best Regards,
Lin
hi, rodfernandez
You could try this way:
Step1:
Create a fact Mes table, then create the relationship with report table by Mes
Step2:
Use this formula to add a measure
Acomulado RCA =
CALCULATE (
COUNTA ( 'Reporte'[Etiqueta] ),
FILTER (
ALLSELECTED ( Mes ),
ISONORAFTER ( 'Mes'[Mes], MAX ( 'Mes'[Mes] ), DESC )
)
)
Result:
and here is my sample pbix file, please try it.
Best Regards,
Lin
Hi Lin.
Thanks for the advice. it really helped me as well having the same issue.
can you please explain me briefly about the table creation?
why did you create a table and how did it help?
