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

Thank you very much for the answer so diligent, attached screenshots of how the information is, what I want is a column like "ModeloAgrupado", but in dax

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Why dont you share your file???  Anyways, try this calculated column formula

 

=IF(COUNTROW(FILTER(Data,Data[Modelo]=EARLIER(Data[Modelo])))<=10,"Otros",[Modelo])

 

Hope this helps.