New Enterprise DNA Initiatives

Totals not working when SELECT ALL is selected in filter

Prov stock 18_12.pbix (189.7 KB)

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

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


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

Try this

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

Prov stock 18_12.pbix (189.6 KB)

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!

Thanks it worked!