Forum Discussion

seba's avatar
seba
Icon for Helper II rankHelper 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.

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
1 year ago

seba 

Please specify if you need a table visual or a calculated table and what's logic for total number of virtual machines -2

  • seba's avatar
    seba
    Icon for Helper II rankHelper II
    1 year ago

    The logic behind "total number of virtual machines -2" is total number of virtual machines minus number 2 hence the value of this column, apart from total, is 2 less then the colum to the left.

     

    Please specify if you need a table visual or a calculated table - hmm, is it possible that I need both? At the end I would like to create a table visual with these numbers, but also would this to be calculated (can be behind the scenes), if that makes sense. Thank you!