Forum Discussion

okusai3000's avatar
okusai3000
Icon for Helper IV rankHelper IV
5 years ago
Solved

SUMMARIZE not Working properly

Hello,   First of all, I'd like to introduce what I'm trying to get. I have the following table, where Antiguedad means how many days has that device been without changing their status. In other wo...
Need Help
  • DataZoe's avatar
    DataZoe
    5 years ago

    okusai3000 It is a bit hard to troubleshoot without the pbix file because the measures are a bit complex. My first try would be to see if this gives you the value you are looking for:

     

    *Antiguedad AVG =
    AVERAGEX ( DISTINCT ( 'fact Logistica_StockEquipos'[Esap_cod] ), [antiguedad] )

DataZoe's avatar
DataZoe
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

okusai3000 It is a bit hard to troubleshoot without the pbix file because the measures are a bit complex. My first try would be to see if this gives you the value you are looking for:

 

*Antiguedad AVG =
AVERAGEX ( DISTINCT ( 'fact Logistica_StockEquipos'[Esap_cod] ), [antiguedad] )

  • DataZoe's avatar
    DataZoe
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    okusai3000 Is it possible to give me the file with some fake data? I am not really sure without looking at the other measures.  

    • okusai3000's avatar
      okusai3000
      Icon for Helper IV rankHelper IV
      5 years ago

      Hey Zoe, I realized that issue comes with the filtered data from my DrillTrought. Your help has been enough, thanks a lot!! 🙂