Forum Discussion

Dave93's avatar
Dave93
Frequent Visitor
9 years ago
Solved

Calculate the average ignoring a specific filter

Hello, I'm having trouble calculating the total average of payment days. The situation is as following:   I have 4 tables that are connected to my calculation: 'Invoice History': stores all the i...
  • Dave93's avatar
    Dave93
    9 years ago

    Hi,

     

    I only want to ignore slicer selection for the measure beceause I want to compare the overall average payment behaviour with the average payment behaviour of the selected debtor. So I want to place multiple measures in a (line-chart) visual. So editing the interaction of the visual won't work in my case.

     

    Here some additional information:

     

     

    I've already made a workaround by creating a additional table but I hope there is a sollution without having to do so. The workaround I made is the following:

     

    Payments = 
FILTER (
    SUMMARIZE (
        'Invoice History';
        'Invoice History'[InvoiceNr];
        "PAID"; AVERAGE ( 'Payment Behaviour'[PaymentDays] );
        "DATUM"; DISTINCT ( 'Invoice History'[DateInvoice] )
    );
    NOT ( ISBLANK ( [PAID] ) )
)

    This new table has some releationships with the 'Invoice History' and the 'Datum' table, but without the Debtors table. But I hope I can get the same results without creating this second table.

Dave93's avatar
Dave93
Frequent Visitor
9 years ago

Hi,

 

I only want to ignore slicer selection for the measure beceause I want to compare the overall average payment behaviour with the average payment behaviour of the selected debtor. So I want to place multiple measures in a (line-chart) visual. So editing the interaction of the visual won't work in my case.

 

Here some additional information:

 

 

I've already made a workaround by creating a additional table but I hope there is a sollution without having to do so. The workaround I made is the following:

 

Payments = 
FILTER (
    SUMMARIZE (
        'Invoice History';
        'Invoice History'[InvoiceNr];
        "PAID"; AVERAGE ( 'Payment Behaviour'[PaymentDays] );
        "DATUM"; DISTINCT ( 'Invoice History'[DateInvoice] )
    );
    NOT ( ISBLANK ( [PAID] ) )
)

This new table has some releationships with the 'Invoice History' and the 'Datum' table, but without the Debtors table. But I hope I can get the same results without creating this second table.

mmainza's avatar
mmainza
Frequent Visitor
8 years ago

hey there. Were you ever able to find the solution you were looking for?

 

I have this same problem and would very much prefer not to make a new table. I figured an ALL or ALLEXCEPT should work, but the measure refuses to ignore a specific filter.