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.

seba's avatar
seba
Helper II
1 year ago

Let me try explain my challange again as I do not think I have been clear enough. First screenshot shows my raw data in a table visual. There are multiple servers, hosting multiple VMs per each.  Obviously, in the total row (number of cores column) power bi adds up all the rows. What I am trying to achieve is to add a number of cores for each server just once, instead for each VM. So in my case Server A -16, B - 24, C 48, total I would like to see would be 48.

 

Ideally, I would like to build a table\matrix (whatever is best for this application) similiar to the one on the second picture, but to have the number of cores added as explained above, as well as be able to multiply a value in the second column (I will have to substract number 2 from it first, hence I need a sum so I can substract from it first and then multiply) by the value in the third (I think now it is impossible due to something I do not fully understand).

 

Much appreciated all the time you spent helping me!