Reply
nmckeown1
Helper I
Helper I
Partially syndicated - Outbound

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.

 

 

1 REPLY 1
Ritaf1983
Super User
Super User

Syndicated - Outbound

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)