Forum Discussion

difolt's avatar
difolt
Frequent Visitor
7 years ago

Cross highlight issue

Hi,   why I can not do something like this? I selected Customer A and specific date from Customer B. And all I need is count. 6+2 = 8. Please find PBIX file. https://drive.google.com/file/d/1Px02...
Show and Tell
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi difolt ,

 

Update:

 

By my tests, I'm afraid that your issue may caused by the row fileds are from different tables.

 

Confirmed by PG, this is by design. We currently do not support filtering of Measures using multiple fields from different tables. Error message is confusing and we'll look into ways of improving and better documenting this.

 

Best  Regards,

Cherry

  • dhwani's avatar
    dhwani
    Microsoft Employee
    5 years ago

    HI , 

    Do we have any updates on this behaviour or is it same. Moreover is there any way to disable include and exclude options when I right click on the visual.

  • rmod32345's avatar
    rmod32345
    Frequent Visitor
    3 years ago

    that is odd if that is intentional, as reports that are built with proper dim/fact tables are not able to cross highlight?