Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCheck if this can help. You can have two measures and switch
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThis works like a charm, thanks! learn something new here everyday
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |