Totals not working when SELECT ALL is selected in filter

Power BI
1

Prov stock 18_12.pbix (189.7 KB)

In the attached file, the funding logic is working fine when single item is selected.
image
image

But when both are selected, the result is not as expected.

image

Expected Result is Apr 2019, Funding =3 , July 2020, Funding = 95, August 2020, Funding = 7.
Basically, the funding across all the Items should be added up, but currently is not happening

2

@Anu
Try this

 Funding (Correct Totals) =
VAR vTable =
    ADDCOLUMNS (
        SUMMARIZE ( Funding, Funding[Item], 'Date'[MonthName] ),
        "@Val", Funding[Funding]
    )
RETURN
    SUMX ( vTable, [@Val] )

Prov stock 18_12.pbix (189.6 KB)

3

Hi @Anu, did the response provided by @MudassirAli help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!

4

Thanks it worked!