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

HI Anonymous,

 

Please provide the sample data for further analysis.

 

BTW, you formula seems like to use count function and if statement to check the count of model column, right?

 

Regards,

Xiaoxin Sheng

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.