Forum Discussion
Measure does not work
Dear all, My below measure does not work...I guess it is related to the fact that it comes from two different fields "salesoffices" and "IObOL new (incl K Group)". How to overcome this problem? Ho...
Orstenpowers , Are these values selected in slicer?
Try like
Sales off vs Country = IF(Max(salesoffices[Sales office country]])=Max('IObOL new (incl K Group)'[Country name]),"identical","deviating")
I did not use a slicer.
Unfortunately your formula does not work. I get message that "column Sales office country]])=Max('IObOL new (incl K Group)'[Country name was not found in table "salesoffices" or is not being allowed to be used in this term...
What needs to be adjusted?