Cumulatively values display in a card according to slicer selection in monthly,quarterly and Yearly

[Dora]

Hi All,

I need to show Cumulative liability according to user selection in Monthly,Quartely and Yearly in a single Card .I Can do it in seperatly as follows.

Formula used:-

Monthly Total Liability= VAR CurrentYr =SELECTEDVALUE(GL_LEDGER_ACCESS[FINANCIAL_YEAR])
VAR CurrentFiscalMonth = SELECTEDVALUE(GL_LEDGER_ACCESS[index 2])

RETURN
CALCULATE([Liability This Month],FILTER(ALL(GL_LEDGER_ACCESS),
GL_LEDGER_ACCESS[FINANCIAL_YEAR]=CurrentYr && GL_LEDGER_ACCESS[index 2] <= CurrentFiscalMonth))

Quartely TotalLI =
VAR CurrentYr =SELECTEDVALUE(GL_LEDGER_ACCESS[FINANCIAL_YEAR])
VAR CurQtr =SELECTEDVALUE(GL_LEDGER_ACCESS[Qtr No])
RETURN
CALCULATE([Liability This Month],FILTER(ALL(GL_LEDGER_ACCESS),GL_LEDGER_ACCESS[FINANCIAL_YEAR]=CurrentYr&& GL_LEDGER_ACCESS[Qtr No]<=CurQtr))

Data table

Please give me solution to show cumulatively Total according to filter selection in a single card.

Thanks in advance,

Best Regards,

Dora

[v-yulgu-msft · Accepted solution]

Hi @Dora,

You need to create an extra table ('SlicerTable') with a single column( [Item] ) which lists all available selections: Monthly,Quartely and Yearly. Later, you should add this column into slicer.

Then, add below measure into card visual:

Cumulative liability =
IF (
    SELECTEDVALUE ( SlicerTable[Item] ) = "Monthly",
    [Monthly Total Liability],
    IF (
        SELECTEDVALUE ( SlicerTable[Item] ) = "Quartely",
        [Quartely TotalLI],
        [Yearly TotalLI]
    )
)

Best regards,

Yuliana Gu

[Dora]

Thank You So much,

Best Regards,

Dora.