Forum Discussion
Find value in another table
Dennis_Pedersen , Try using below DAX
Minimum Turnover =
VAR Discount = [cust_disc] // Replace [cust_disc] with your actual measure for calculating the total discount on a customerRETURN
CALCULATE(
SUM(discounttable[Turnover]),
discounttable[Discount] >= Discount,
FILTER(
ALL(discounttable),
discounttable[Discount] >= Discount
)
)
Dennis_Pedersen , Try using below DAX
Minimum Turnover =
VAR Discount = [cust_disc] // Replace [cust_disc] with your actual measure for calculating the total discount on a customer
RETURN
CALCULATE(
SUM(discounttable[Turnover]),
discounttable[Discount] >= Discount,
FILTER(
ALL(discounttable),
discounttable[Discount] >= Discount
)
)
Thanks a lot. That helped me in the right direction.
However I had to ammend it a little, with making a discount from and discount to, to make it work correct.
VAR Discount = [Total discount_ %]
RETURN
CALCULATE(
[Amount from],
Discount >=DIM_Segmentering[Discount from],
FILTER(
ALL(DIM_Segmentering),
Discount<DIM_Segmentering[Discount to]
)
)