Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Hoping someone could help me create the following formula where ...
DistinctCount Voucher where Payment is greater or less than 0
Thank you!
Solved! Go to Solution.
Can you try removing the "FILTER (" and just add one ")" at the end?
Sorry, on phone and syntax may be wrong on my part! Apologies.
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Can you try removing the "FILTER (" and just add one ")" at the end?
Sorry, on phone and syntax may be wrong on my part! Apologies.
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @jonnyA, can you try something like the following?
Measure =
VAR _1 = DISTINCTCOUNT ( Table[Voucher] )
VAR _2 = CALCULATE ( _1 , FILTER ( Table[Payment] <> 0 ) )
RETURN
_2
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |