This is how my graph looks after I change the settings. The issue is that the black line is going ober red line and according to business rules It is not possible. We are calculating instances per thousand vehicle and the rule is that 6 months will always have more records then 3 and 12 always ahve more records then 6. By looking at the graph its showing that in 6 months we had more incidents then 12 months. Which is wrong. Is there anyway to create continous line that matches 3 months in service line? I am creating this via table and it is missing those months.
so basically I asking 2 questions.
1. Is there anyway for the line to continue without crossing any line?
2. if thats not possible then how would I replace the missing months in 6 months of service from 3.
I apologize if I am not clear, pleaase ask for explanation if you need to.
Hi @mukhan169 ,
How is your source table like? Please illustrate the expected result and calculation rule with examples.
Thank you for responding v-yulgu-msft and I apologize for not adding any details. So the rule is 6 MIS for January is a running total of 3 MIS in January. 6 MIS for february is runing total of 3 MIS. The issue I am having is that when I dont have particular month in 6 MIS for example 6 MIS April I want value for 3 MIS from april simply copy to 6 MIS. It should look like this
6 2017 April 0.47
here are the measures I am using. Following calculates the IPTV by using another measures.
MISGroup is field in model that has 3,6,12 and 24 values. its a calculated field which is correct I double checked it.
IPTV column in above pic is the following measure.
After investigation I think it is more issue of modeling. I have generated a date table that has a relationship to data that is bringing all the records from the transection table.
When there is no record for April (as shown in my previous post) for MIS (month is service) 6 it doesnt show the value of April's 3 MIS for the same year. I am not sure how to resolve that.
I am sorry to keep posting but that where it comes down to.
I have a table BinSelect
I have a column in my trasection table that have 3,6,12 and 24. I have created one measure