Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need a new measure formula for getting a distinct count of "IDs" while filtering for values on "Profit" that are less than 0 and adding a filter for "New" in the Used/New field so it only pulls those values. For some reason I'm getting errors with the > when I use the calculate function.
Thanks for any help you can provide!
Hello @NCPowerBI.,
Here's a measure formula that should give you the distinct count of IDs:
DistinctCountIDs =
CALCULATE(
DISTINCTCOUNT(Table[ID]),
FILTER(
Table,
Table[Profit] < 0 && Table[Used/New] = "New"
)
)
Let me know if you have any further questions.
Hi Sahir, for whatever reason it's still giving me an issue. It's not giving me any values when I put it on the view. I neglected to mention above, there are two different fields I am filtering for at the end - "New" and "Non". Let me know your thoughts!
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
54 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |