Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Hi @Anonymous ,
I'm not clear about the error message. Maybe you could have a try like below.
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
Hi @Anonymous ,
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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/
as i explained, i need to group by report into different fields ( operatore name and group name)
i need to show operator name or group name in report, in measure i just have total amount!
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