Change measure results depending on a slicer using Power BI

[Anonymous]

I'm making a report using Power BI. The data that I'll show is the commulative ammount of a turnover. Inside the data source I've this data.

Month	Ammount	Filter
1	17	option A
1	15	Option B
1	16	Option C
2	12	Option A
2	14	Option B
2	13	Option C
3	17	Option A
3	18	Option B
3	16	Option C

I've this on the report:

For the filter column I'll create a slicer and when there's nothing selected the sum of all the options must be show in the graph, when selected on or multiple only the selections must be shown in the graph. To create the graph I've created this measure:

Commulative ammount = 
CALCULATE(
    SUM('Turnover'[Ammount]),
    FILTER(
        ALL('Turnover'), 
        'Turnover'[Month] <= MAX('Turnover'[Month])
    )
) 

In this situation, when I select an option from the filters, the graph doesn't change the data. How could I do this?

[amitchandak]

@Anonymous , use allselected

Commulative ammount = 
CALCULATE(
    SUM('Turnover'[Ammount]),
    FILTER(
        ALLSELECTED('Turnover'), 
        'Turnover'[Month] <= MAX('Turnover'[Month])
    )
) 

[mahoneypat]

Try ALLSELECTED() instead of ALL().

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[ThoSch-Ger]

Do you get the Options out of the table 'Turnover'?

In that case try:

Commulative ammount = 
CALCULATE(
    SUM('Turnover'[Ammount]),
    FILTER(
        ALLEXCEPT('Turnover', 'Turnover'[Filter] ), 
        'Turnover'[Month] <= MAX('Turnover'[Month])
    )
) 

[FarhanAhmed]

Commulative ammount = 
CALCULATE(
    SUM('Turnover'[Ammount]),
    FILTER(
        'Turnover', 
        'Turnover'[Month] <= MAX('Turnover'[Month])
    )
)

[Anonymous · Accepted solution]

I think you should use ALLSELECTED instead of ALL for the desired results:

Commulative ammount = 
CALCULATE(
    SUM('Turnover'[Ammount]),
    FILTER(
        ALLSELECTED('Turnover'), 
        'Turnover'[Month] <= MAX('Turnover'[Month])
    )
)