Forum Discussion
Same Column Variance
Hello, I have Table "Vendor_Rate" where I want to find out product price difference against "Current Rate" for all the vendors : Vendor 1 Rate, Vendor 2 Rate , Vendor 3 Rate Rate ...
Anonymous
You just need to change the [Current Price] measure to hold onto the city filter.
Current Price = CALCULATE ( [Vendor Price], ALLEXCEPT( Vendor_Rate, Vendor_Rate[City] ), Vendor_Rate[Rate] = "Current Rate" )
Thank you so much. Only one thing is missing.
I have rates for mutiple cities such as city 1, city 2, city 3, City 4. With above Current Price measure , its calculating all cities current rate. How do I measure it per city?
I appreciate your help
Anonymous
You just need to change the [Current Price] measure to hold onto the city filter.
Current Price =
CALCULATE (
[Vendor Price],
ALLEXCEPT( Vendor_Rate, Vendor_Rate[City] ),
Vendor_Rate[Rate] = "Current Rate"
)