Forum Discussion
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:
6 Replies
- Greg_DecklerCommunity Champion
Tough to tell exacty, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- v-xuding-msftCommunity Support
Hi Anonymous ,
I'm not clear about the error message. Maybe you could have a try like below.
Column = IF('An'[Measure] = True,1,2)If it can't work, please share a dummy pbix file or some sample data. Then we will understand clearly.- AnonymousNot applicable
Hi,
problem is when i change the filter in data slice. result is same(there is no diffrenece between true and false)
result is same , it seems powebil couldnt identify result of
if( 'Anonymize'[Measure]= "True" , ...)- v-xuding-msftCommunity Support
Hi Anonymous ,
Please try to create a measure using the formula rather than a calculated column.
And you could reference the blog to learn more about the difference between them.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/