Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parameterize column based on customer request

Hi

im new in powerbi , i use to make report in tableau, in tabluea its possible to create parameters and use it in formula, how can i implement it in powerbi, for more clearfition look at below desc:

there is report to show report based on OperatorName - operatorgroup

so i have paramterte that user can choice from drop down (if user select Operator name so i need to group by data on customer name otherwise operatore Group)

 

in tableau its easu just add one line 

Operator = 

iif([Anonymize?]=False,[Loading Operator Name],Str([Loading Operator GroupName]))

 

to implement it , i use to add new table into powerbi (OperatorName ,) operatorgroup, when user select one of option ,

it seesm it impossible to pass selected value into DAX to calculated column ( non measure object)

ERROR:

 
Column = if( Anonymize[anonymize] = "False" , "1" , "2")

 

 

6 Replies