Forum Discussion

AOD's avatar
AOD
Icon for Helper III rankHelper III
5 years ago
Solved

Incremental Stacked bar

Hi All,

I have daily registration with status cofirmed and rejected on stack bar.

I wanted to have daily incremental registraction with both status.

 

Eg : in KPI with Light blue  date 19/12/20 I want figure as  total of '319 + 259 + 277 ' instead of 277

Same for dark blue .

Thanks in advance for your help.

 

 

Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hi AOD ,

     

    We can create a measure to meet your requirement.

     

    Measure = 
CALCULATE(SUM('Table'[KPI]),FILTER(ALLSELECTED('Table'),'Table'[status]=MAX('Table'[status]) && 'Table'[Date]<=MAX('Table'[Date])))

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    BTW, pbix as attached.

2 Replies

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

    Hi AOD ,

     

    We can create a measure to meet your requirement.

     

    Measure = 
CALCULATE(SUM('Table'[KPI]),FILTER(ALLSELECTED('Table'),'Table'[status]=MAX('Table'[status]) && 'Table'[Date]<=MAX('Table'[Date])))

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    BTW, pbix as attached.