Forum Discussion
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 ...
Hi,
Try these measures
Measure = min(Data[Number of cores])
Measure1 = SUMX(VALUES(Data[Server name]),[Measure])
Hope this helps.
Hi,
Write these measures
Numberofcores = min(Data[Number of cores])
Measure 1 = countrows(Data)
I cannot understand the last measure.
I assume the measure you had trouble understading is "total number of virtual machines -2" which 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. I should have been clearer.
Write these measures
Measure 2 = [Measure 1]-2
Measure 3 = SUMX(VALUES(DATA[Server name]),[Measure 2])
Hope this helps.
I have added an additional explanation above, hope this will be easier to understand. Thank you!
