Forum Discussion

Wiene24's avatar
Wiene24
Icon for Helper II rankHelper II
7 years ago

Two different averages in one table

Hi,

 

I have a little problem.

 

I have one table with costumors and there is recorded how the invoiceprocess goes.

I have another table with invoices and in there I have a colomn saying how fast after the order the invoice was sent.

 

Now I have a table that gives me from all costumers what there average is on how fast the invoice was send after the order.

I have a differente table that gives me from all invoiceprocesses the average on how fast the invoice was send after the order.

This second number I want to use in the first table to show the difference.

 

I have used this: 

Verschil = CALCULATE(AVERAGE('dba KO'[Datumverschil]);ALLEXCEPT('dba Relatie';'dba Relatie'[FacturatieWijzeCode]))
 
But then the table changes showing me rows without values, because they have a invoiceprocess but no invoice.
And because they dont have a invoice there is no average.

1 Reply

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Wiene24 ,

    What could you want to show with your Verschil measure? The difference between two average column are which two columns? Could you please offer your pbix and your desired result if possible?

     

    Regards,

    Daniel He