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.

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

Write these measures

Measure 2 = [Measure 1]-2

Measure 3 = SUMX(VALUES(DATA[Server name]),[Measure 2])

Hope this helps.

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

I have added an additional explanation above, hope this will be easier to understand. Thank you!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    1 year ago

    No, at least i am not clear about what you want.  Sharing an image is useless.  Atleast share data in a format that can be pasted in an MS Excel file.  Show the expected result very cleary.