Forum Discussion
Solved
Substraction in measure
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
)
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
5 Replies
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...
Onsite % new is a measure
onsite %new = DIVIDE(SUM(DATE_Detail[tot_num_on_site_hrgs]),SUM(DATE_Detail[Total otv]) )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
I think I got it...thank you!!
