Changing part of measure based on slicer selection

[Timo1980]

Hi All,

I'm wondering if the following in possible. In the example table below I would like to change the Indexed calculation based on a different Index selection based on a slicer input, in the front end of power BI. The table should remain the same but basicly change the indexed calculation if for example i would select month 1(jan) as the index, so line would then change to 100% etc.  any help would be greatly appreciated!

Month	ASP	Index	Indexed
1	180		98%
2	176	176	100%
3	178		99%
4	176		100%
5	180		98%
6	174		101%
7	173		102%
8	179		99%
9	174		101%
10	173		102%
11	175		101%
12	176		100%
	Measure=SUMX(Sales)/SUMX(Volume)	Same Measure as ASP, but called index	Measure=INDEX/ASP	<-- Change index value based on slicer

[amitchandak]

Check if this can help. You can have two measures and switch

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[MFelix · Accepted solution]

Hi @Timo1980 ,

Create a table with month/year format to use as your filter then add the following measure:

Indexed = 
VAR Index =
    CALCULATE (
        SUM ( Sales[ASP] );
        FILTER (
            ALL ( Sales[Month ] );
            Sales[Month ] = MIN ( 'Base:_Month'[Base Month] )
        )
    )
RETURN
    Index / SUM ( Sales[ASP] )

Replace the Sum(SALES[ASP]) by your ASP measure 

Then just use the slicer for changing the base values.

this calcultion may need a lot of adjustments for your model but the tought process is this one.

Check PBIX file attach

[Timo1980]

This works like a charm, thanks! learn something new here everyday