Forum Discussion
Building a dashboard
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!
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.