Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
You could try something like this. For each of you sets of parameters(number of users, cost pr user), createa a measure like this
CostParameter = SWITCH ( TRUE (); SELECTEDVALUE ( DimDate[Year] ) = 2016; CostPrUser2016[CostPrUser2016 Value]; SELECTEDVALUE ( DimDate[Year] ) = 2017; CostPrUser2017[CostPrUser2017 Value]; SELECTEDVALUE ( DimDate[Year] ) = 2018; CostPrUser2018[CostPrUser2018 Value]; 1 )
Then create a measure like this
Measure = SUM ( Table[Number of users ] ) * [UserParameter] * SUM ( Table[Cost pr unit] ) * [CostParameter]
Add year to the x-axis, and measure as value. If you need a trend line, you can add this through the analytics options of the chart.
cheers,
Hi @Anonymous
Sorry not very clear from you post what you are looking for. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
You could try something like this. For each of you sets of parameters(number of users, cost pr user), createa a measure like this
CostParameter = SWITCH ( TRUE (); SELECTEDVALUE ( DimDate[Year] ) = 2016; CostPrUser2016[CostPrUser2016 Value]; SELECTEDVALUE ( DimDate[Year] ) = 2017; CostPrUser2017[CostPrUser2017 Value]; SELECTEDVALUE ( DimDate[Year] ) = 2018; CostPrUser2018[CostPrUser2018 Value]; 1 )
Then create a measure like this
Measure = SUM ( Table[Number of users ] ) * [UserParameter] * SUM ( Table[Cost pr unit] ) * [CostParameter]
Add year to the x-axis, and measure as value. If you need a trend line, you can add this through the analytics options of the chart.
cheers,
brings back a blank
When you set up you parameter, was the first step 0? If you look at the tables generated by the parameter, there are 2 fields. Look at the one which does not end with value. It will say something Generateseries(0;20;1). The first value is the start value. By default, the when setting a new parameter, this value is 0.
If this does not solve you issue, please post the code of you measure
This is what the page would look like... I assume that for each year, there would be 2 parameters (example, for 2017 there would be 1 parameter for # of Users and 1 parameter for $ per user.
Year # Of Users $ Per User Total Cost
2017 | User Input | User Input | *=#ofusers X costperunit* |
2018 | User Input | User Input | *=#ofusers X costperunit* |
2019 | User Input | User Input | *=#ofusers X costperunit* |
The client would be able to manually input into the fields above
the end result would look like this
Year # Of Users $Per User Total Cost
2017 | 5 | 50 | 250 |
2018 | 10 | 55 | 550 |
2019 | 8 | 60 | 480 |
The visual would look like this
Hi,
it is not clear to me what your data look like, or how you want you visualization to look like. Do you want the line chart years on the x-axis, or do you want the actual parameter values?
Perhaps you could create a mock-up of your desired result, and also create a sample dataset?
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |