Forum Discussion

Wilsonr's avatar
Wilsonr
Helper I
7 years ago

Cross-Highlighting on Different Aggregations

I have a measure in a table of measures which is the sum of the Quantity of each Product we manufacture. The Plant information is contained in a related table called Plant. The Products are owned by ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Wilsonr,

 

Can you please share more detail information with some sample data to test?
In addition, I'd like to suggest you enter to manage relationship and modify 'cross filter direction' option to 'both' and try again.

 

Regards,
Xiaoxin Sheng

Wilsonr's avatar
Wilsonr
Helper I
7 years ago

Yes, of course I can provide more detail. Where can I drop a PBI report file?

 

My cross-filter directions are already set to both. I have been trying to debug, and I noticed that if I use a simple measure (i.e. just a sum of quantities), my results are as expected. However my measures aren't actually that simple - they are in fact a division of the sum of two native columns for the latest month. Why would this present a problem?

% Loading  = CALCULATE(SUM(Measures[ACTUAL_QTY]) / SUM(Measures[FORECASTED_QTY])))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Wilsonr,

     

    When you use a measure with complex condition and filters, it not calculate on summarize category hierarchy level. It will drill to detail row level to calculate, then summary these results.

     

    Regards,

    Xiaoxin Sheng