Forum Discussion

fabd's avatar
fabd
Icon for Helper I rankHelper I
6 years ago
Solved

How to group by ?

Hi, sorry for this basic question. I hang around the community before posting. I found some help, but i was not able to implement these advice in my case.   So, i have a following table :   ...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hello @fabd ,

    I'm sorry for my mistake. Please try the formula below.

    Table 2 = 
SELECTCOLUMNS (
    'Table',
    "Model", 'Table'[Model],
    "DateMonth", 'Table'[datemonth],
    "CPU", 'Table'[CPU],
    "Frequency", 'Table'[Frequency],
    "RAM", 'Table'[RAM],
    "DistinctCount", CALCULATE (
        DISTINCTCOUNT ( 'Table'[Model] ),
        ALLEXCEPT ( 'Table', 'Table'[datemonth] )
    )
)

    3.PNG

    I changed the sample data. For more information, see the attachment.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

fabd , Can you share the summarize you have used.

 

What is left for Distinct count after selecting model

summarize(Table, Table[model], Table[datemonth], Table[CPU], Table[Frequency], Table[RAM] ,"Unique Model", distinctCOUNT(Table[Name]))

fabd's avatar
fabd
Icon for Helper I rankHelper I
6 years ago

Hello guys,

 

Following your advice, here is the result with the summarize()

 

For the matrix, this is only what i successed to do

 

 

I would like something like this in a simple table that i could export to csv after :

 

serverModelName,manufacturer,numCpus,cpuType,cpuGhz,memGb,numberOfServers,dateOfPurchase,pricePerServer,
batchType,dataCenterName