Forum Discussion

seba's avatar
seba
Helper II
1 year ago
Solved

Building a dashboard

Hi! I was wondering if someone could help me build a table as presented on the screenshot. Struggling to achieve the effect I am looking for, as the "number of total cores", as well as "total number ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    Try these measures

    Measure = min(Data[Number of cores])

    Measure1 = SUMX(VALUES(Data[Server name]),[Measure])

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

HI seba,

I'd like to suggest you tried to use 'unpivot columns' feature on this table to transform the table structure to expected results: (you can use 'server name' and 'cores' as the group)

Unpivot columns - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng