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.
Ashish_Mathur Fowmy chauhans85 Anonymous thank you for your help and feedback so far. I was not around for a while hence the delay, apologies. I have attached a table with the data so hopefully it will make it easier. I will do so whenever I ask for help going forward.
The table contains a list of virtual machines (column C) hosted on various servers (column A). Each server can host multiple virtual machines. Column B represents a number of cores per server. To clarify, values in column B for each VM do not add up - serverA is 16 cores, serverB is 24, and serverC is 48 cores.
| Server Name | Number of Cores | Virtual Machine Name |
| Server A | 16 | VM A |
| Server A | 16 | VM B |
| Server A | 16 | VM C |
| Server B | 24 | VM D |
| Server B | 24 | VM E |
| Server B | 24 | VM F |
| Server B | 24 | VM G |
| Server C | 48 | VM H |
| Server C | 48 | VM I |
My task is to get "expected" total values for the above table. The challange is total value in colum B (cores per server). By "default" Power BI will add number of cores from all rows, and this not what I want. I seem unable to find a function which would count a number of cores per each server but just once no matter how many virtual machines they host. I would like to be able to see value 88 (cores for each server added just once - 16+24+48) for this specific example.
I can see how my previous post were confusing, hope this is clearer and easier to understand. Thank you!
Hi,
Try these measures
Measure = min(Data[Number of cores])
Measure1 = SUMX(VALUES(Data[Server name]),[Measure])
Hope this helps.