Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Slow matric

Hi all,   I created a measure with filters from 2 different tables :    = CALCULATE(DISTINCTCOUNT('Major table'[ENR_Chrono]);FILTER('Major table';'Major table'[ENR_Statut_de_traitement]="Réalisé...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    I think your formula is very simple.

    And if you try this formula:

    = CALCULATE(DISTINCTCOUNT('Major table'[ENR_Chrono]);FILTER('Major table';'Major table'[ENR_Statut_de_traitement]="Réalisé"&&RELATED(equipe_IBM[ENR_IBM_Team])="oui"))

    Or you could try to merge two tables into one table as below:

    https://radacad.com/append-vs-merge-in-power-bi-and-power-query

     

    Best Regards,

    Lin

     

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

HI, Anonymous 

I think your formula is very simple.

And if you try this formula:

= CALCULATE(DISTINCTCOUNT('Major table'[ENR_Chrono]);FILTER('Major table';'Major table'[ENR_Statut_de_traitement]="Réalisé"&&RELATED(equipe_IBM[ENR_IBM_Team])="oui"))

Or you could try to merge two tables into one table as below:

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

 

Best Regards,

Lin

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    Ok I'll try to merge the 2 tables because with your measure my matrix are really slow too.

    Thank you !