- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Calculate assumption for total clients (count any negative values as blank)
I need data for total clients signed up for a service:
Referred clients + self-referrals = total clients signed up
I only have the data for:
Total reffered clients
Overall Total clients signed up
These are both calculated measures from different tables.
I need the total clients self-referred- which we assume to be =(Total clients signed up subtract referred clients)
I can use a basic DAX measure but this provides errors for when the overall clients signed up is less than referred clients - which can happen if referrals are declined.
Question: Basically if the total self-reffered equates to a negative number, I need it to populate as zero as this means no clients were self-referred.
Eg. for one month, I have:
24 referred clients
of this, 20 referrals were accepted
20 overall clients signed up
which means self-referrals were assumed to be zero - but it is populating as -4.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @nmckeown1
Generally, you can create a measure with the conditional logic like :
If ([your measure]<0 ,0 , [your measure]).
For more detailed suggestions please share a pbix or some dummy data that keeps the raw data structure with expected results. It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
03-11-2024 09:54 AM | |||
03-19-2024 08:26 PM | |||
04-15-2024 07:37 AM | |||
Anonymous
| 12-18-2023 05:19 AM | ||
11-04-2022 08:35 AM |
User | Count |
---|---|
89 | |
82 | |
54 | |
40 | |
35 |