Forum Discussion

ngct1112's avatar
ngct1112
Icon for Post Patron rankPost Patron
6 years ago

BI Desktop Parameter with Columns

Hi, I would like to create a parameter as a master slicer to control the page in BI Is it possible I could have a slicer to select 2 columns - 1."Profit%" or  2."Pass%" to influence the measure like...
Need Help
ngct1112's avatar
ngct1112
Icon for Post Patron rankPost Patron
6 years ago

amitchandak Anonymous 
But is it possible I could have a parameter not a Number range but Text(Columns).

I find it I could not put the text into the What-if parameter somehow.

 

With the measure, the measure could be dynamically changed with the parameter, making the formula like that when I choose on the slicer,

measure = CALCULATE(SUMX('Table','Table'[Profit]),FILTER('Table','Table'[PARAMETER_COLUMN]=>5%))

--> measure = CALCULATE(SUMX('Table','Table'[Profit]),FILTER('Table','Table'[Pass%]=>5%))
--> measure = CALCULATE(SUMX('Table','Table'[Profit]),FILTER('Table','Table'[Profit%]=>5%))

 

 

 

Great thanks if there are any advices

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi ngct1112 ,

    The what-if parameter can only be used for numeric data. Can I know what's the final result you want? Is the data filter by the slicer for (Profit %>5% || Pass %>50) or (Profit %>50 && Pass %>50)? And what are the text parameters you mentioned? That is from the fact field in table or a measure?

    Best Regards

    Rena