Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

comparative measure for calculated column

Good evening Teachers Again I come to you for help, the following happens: I need to create a calculated column that groups information from computer models, where if the count of the ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this calculated column formula

     

    =if(CALCULATE(COUNTROWS(Table1),FILTER(Table1,[Modelo]=EARLIER([Modelo])))<10,"Others",[Modelo])

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Ashish_Mathur

Anonymous

Thank you very much for the response so agile, I really do not know how to attach the file by this very place, so attach the link to download the .xls file

Even I have not managed to apply dax correctly in this type of cases, so what I have to do is to lower in excel and do it in the classic way.
Any help is appreciated
** question: can be obtained with the use of variables "VAR"
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

You can upload to onedrive or google drive and share the link here.

 

Regards,

Xiaoxin Sheng