Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a requirement where I need to display True/False for each SourceName, if Count of "order_id" column(coming from "Transaction" table) is > 0 then True else False, after filtering "TransactionYearMonth" from "Transaction" table in{"Jan-20","Feb-20","Mar-20"} and TransactionType'[Type]="Ticket"
Right now, it looks like this:
Correct Result:
How to add this filter?
FILTER('olap dim_TransactionType','olap dim_TransactionType'[Type]="Ticket")
in this calculated column
Solved! Go to Solution.
@Anonymous Which table is the calculated column in? Is there a relationship between type and transaction table? Looks like it's in the transaction table?? You may not need the RELATEDTABLE function.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@Anonymous Which table is the calculated column in? Is there a relationship between type and transaction table? Looks like it's in the transaction table?? You may not need the RELATEDTABLE function.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hi @AllisonKennedy,
Thanks, this is giving the correct result and has resolved my issue.😊
@Anonymous That's great to hear - please 'Accept as Solution' to mark the helpful post as a solution so others can find it easier and also know this post is solved.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |