Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
sraj
Responsive Resident
Responsive Resident

Substraction in measure

‎08-10-2021 11:04 AM

Hi,

 

Can someone please tell me if I am subtracting it the right way between years?

 

Onsite (76.85 - 76.96) =   - 0.11

 

2020 vs 2021 onsite =

CALCULATE(
    [onsite %new],
    uv_PBI_HEARING_DATE_Detail[Year] = 2021
)
-
CALCULATE(
    [onsite %new],
    uv_PBI_HEARING_DATE_Detail[Year] = 2020
)
 
Capture 2.PNG
Labels:
Message 1 of 6
591 Views
0
1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion
In response to sraj

‎08-10-2021 11:22 AM

@sraj Well, whether it is correct or not is going to depend on your relationship between your two tables:

DATE_Detail

uv_PBI_HEARING_DATE_Detail



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Message 4 of 6
551 Views
0
5 REPLIES 5
Greg_Deckler
Community Champion
Community Champion

‎08-10-2021 11:16 AM

@sraj Hard to say, what does that measure bring back in a Card visual? What is [onsite %new] as in what is the calculation? Other than that, yes, you are using a minus sign, so seems like you are subtracting...



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 6
577 Views
0
sraj
Responsive Resident
Responsive Resident
In response to Greg_Deckler

‎08-10-2021 11:37 AM

I think I got it...thank you!!

Message 6 of 6
545 Views
0
sraj
Responsive Resident
Responsive Resident
In response to Greg_Deckler

‎08-10-2021 11:19 AM

Onsite % new is a measure

onsite %new = DIVIDE(SUM(DATE_Detail[tot_num_on_site_hrgs]),SUM(DATE_Detail[Total otv]) )
Message 3 of 6
555 Views
0
Greg_Deckler
Community Champion
Community Champion
In response to sraj

‎08-10-2021 11:22 AM

@sraj Well, whether it is correct or not is going to depend on your relationship between your two tables:

DATE_Detail

uv_PBI_HEARING_DATE_Detail



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Message 4 of 6
552 Views
0
sraj
Responsive Resident
Responsive Resident
In response to Greg_Deckler

‎08-10-2021 11:29 AM

Its in the same table not different, the previous just got deleted.

Message 5 of 6
550 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All