What if parameter on SSAS

[sinanalmac]

Hi all,

I used "what if parameter" function in a power BI report to filter some measures and values. It perfectly works. But Report's data is so big. file size reached 700 MB.  It works so slow when we want to see the report.  

We decided to move the repot's data to the Analysis server to make a live connection. We made all structure except "what if parameter" filter in the analysis server.

Because there is no what if parameter" in the analysis server

Do you have any idea?   What can I use instead of "What if parameter" in analysis server?

I tried to make the same table structure in the analysis server. but it didn't work 

 Target_parameter table is  created by "what if parameter".

Target Paramater = GENERATESERIES(0, 115000, 100)

Target Paramater Value = SELECTEDVALUE('Target Paramater'[Target Paramater])

 target parameter_II table is created by me.  on analysis server 

Target_Parameter_II = SELECTCOLUMNS ( CALENDAR ( 1, 115 ), "target_parameter_II", INT ( [Date]*100) )

target_parameter_value_II = IF (HASONEVALUE(Target_Parameter_II[target_parameter_II])=TRUE(),MAx(Target_Parameter_II[target_parameter_II]),0)

I'm sending my file  If you want to look at it 

https://www.dropbox.com/sh/w4fuymtxiktwlpi/AACRx-JwF2QlVAocqj066qVZa?dl=0

best regards

[v-juanli-msft]

Hi @sinanalmac 

Do you connect to SSAS Multidimensional Cube or SSAS Tabular data?

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[sinanalmac]

Hi @v-juanli-msft 
I connect to SSAS tabular data  My SQL  version  is 2016
BEst  regards
Sinan 

[Anonymous]

@sinanalmac were you able to find a solution?