topic create a Aggregation on column with What If parameters selected value in DAX Commands and Tips

create a Aggregation on column with What If parameters selected value

Anonymous — Thu, 23 Jun 2022 11:18:33 GMT

Hello Community,
I want to myltiply the column dynamically when the end user pass the value using what if parameters slicer.
Lets say end user is selecting the value "3" now i have to use that value and aggregate it with a column and whole report should filter with the new values. Any help will be helpful.

Thanks in advance

Re: create a Aggregation on column with What If parameters selected value

ManguilibeKAO — Sat, 25 Jun 2022 08:26:02 GMT

Hi tirth_dexter,

Could you give some input data and the corresponding output you want?

Best regards.

Re: create a Aggregation on column with What If parameters selected value

Anonymous — Mon, 27 Jun 2022 07:47:57 GMT

Thanks ManguilibeKAO But I found the solution just have to create a parameter with range of values and pass the user selected value from slicer to measure to perform calculation.