Forum Discussion

Paul_Rockliffe's avatar
Paul_Rockliffe
Frequent Visitor
3 years ago

Cross-Filtering a Visual Based on an Inactive Relationship

I have an ative relationship between a date table and a dimension table based on the processing date and an inactive relationship based on the due date.   I've created a Measure that allows me to c...
DAX
Paul_Rockliffe's avatar
Paul_Rockliffe
Frequent Visitor
3 years ago

Thanks, yes that might work too. 

 

I ended up finding a similar question and adapting the answer.  My solution isn't perfect because I couldn't find a way to do this that didn't use CALCULATE with an Aggregation, so the result is always a single Row.  But by putting another column from my table into the Table visual it then returns a single Row for every Row, which removes the aggregation in practice.  This is fine for this one, as I wanted a couple of columns anyway.

 

Measure is:

 

Selected Measures by Due Date =
    CALCULATE(
        MAXX('Live Commission Dashboard',
            'Live Commission Dashboard'[Status]),
                ALLSELECTED('Month Calendar'[Date]),
                USERELATIONSHIP('Month Calendar'[Date], 'Live Commission Dashboard'[Due Date])
            )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI Paul_Rockliffe,

    AFAIK, current measure expression not able to use as axis or category to expand the aggregate records. You can only add more category fields to expand aggregated row contexts.
    Regards,

    Xiaoxin Sheng