Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
We have a single table with a list of Virtual Machines and their day-wise consumption for a complete month. Each virtual machine, it has 31 separate entries for each day, respectively. We have calculated the value for cost as
VM_Cost= Table1[Consumed Hours] * Table1[Cost_Per_Hour]
Now, along with this value, we also need to add a fixed component of say 10000. So 10000 has to be divided and applied equally to all the virtual machines.
Fixed_Cost = 1000/ DISTINCTCOUNT[VM Name]
But, when we add this to the above formula of VM_Cost, this value is getting added for each and every row that is for 31 days individually, and for every calculation, it is taking the distinct count value as 1.
How can we add this fixed value uniformly across all the running days for each virtual machine?
Hi, cant you use measure ? Does not look like its something you would want to filter on?
Not sure how you are adding the fixed cost, share few of the dax snippets and a screenshot.
VM_Cost =
var instance_count = SUMX(VALUES(UsageDetails), CALCULATE(DISTINCTCOUNT(UsageDetails[Instance ID])))
return
{
SUMX(VALUES(UsageDetails), 10 * RELATED('UsageDetails'[Consume Quantity])) +
(DIVIDE(DIVIDE([FixedPrice], instance_count ), DISTINCTCOUNT(UsageDetails[Day]))
}
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |