Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Win a FREE 3 Day Ticket to FabCon Vienna. Apply now

Reply
AnthFromIngram
Frequent Visitor

Calculation doesn't seem to be working. Calculate(Sum with filter that checks for text in name

Net New ARR =
VAR _Net_Sales1 =
CALCULATE(
    SUM(Sales[NetSalesAmount]),
    FILTER(Subscription,Subscription[Plan Name] <> "(NCE COM ANN)" || Subscription[Plan Name] <> "(Annual Pre-Paid)")
)
VAR _Net_Sales2 =
CALCULATE(
    SUM(Sales[NetSalesAmount]),
    FILTER(Subscription,Subscription[Plan Name] = "(NCE COM ANN)" || Subscription[Plan Name] = "(Annual Pre-Paid)")
)
RETURN
_Net_Sales1 * 12 + _Net_Sales2

Someone here helped me come up with this solution, essentially we have 1 Net Sales column that calculates MRR, but it's pulling in and multiplying the annual paid up front subscriptions by 12, so the above formula was a solution to add annual subscriptions to (monthly subscriptions*12)

 

for some reason it isn't working, I'm selecting a row right now that has an annual purchase of 3000, and the Net MRR measure is showing 36k (It's multiplying annual subscriptions by 12 for some reason) not sure why. 

 

any help is appreciated.

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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