Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I am evaluating the below DAX expression
Solved! Go to Solution.
Hi @Mystery
The code you show will yield the same result in every row and it will be TRUE if the table contains that combination anywhere, in any of the rows. Check the syntax for CONTAINS
What do you need? A calculated column that tells you whether that row has the combination (ProductID, Revenue) you show? If so, you can use this for your column:
Column 2 = bi_salesFact[ProductID]="785" && bi_salesFact[Revenue]=68.1975
or this if you were to modify your code to make it work:
Column 2 = contains(CALCULATETABLE(bi_salesFact) ,bi_salesFact[ProductID],"785",bi_salesFact[Revenue],68.1975)
The first version is simpler and more efficient.The second is just for illustrative purposes, but not recommended.
Hi @Mystery
The code you show will yield the same result in every row and it will be TRUE if the table contains that combination anywhere, in any of the rows. Check the syntax for CONTAINS
What do you need? A calculated column that tells you whether that row has the combination (ProductID, Revenue) you show? If so, you can use this for your column:
Column 2 = bi_salesFact[ProductID]="785" && bi_salesFact[Revenue]=68.1975
or this if you were to modify your code to make it work:
Column 2 = contains(CALCULATETABLE(bi_salesFact) ,bi_salesFact[ProductID],"785",bi_salesFact[Revenue],68.1975)
The first version is simpler and more efficient.The second is just for illustrative purposes, but not recommended.
Thanks let me check that out.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |