Modelling Issue

[mukhan169]

Good Evening experts,

I have modelling issue. I have claims table which has only 4 models but in my sales I have 6 models. Part of the formula is to calculate the count of claims and divide it by Total sales. Which is not producing the right results as counts are for 4 models from claims but we are diving it sales total of 6 models. If someone can point me in right direction that will be greatly appreciated.

Here is the link to the sample file

Modeling Issue

Thanks in advance for the help.

[v-yuta-msft]

@mukhan169 ,

I have modelling issue. I have claims table which has only 4 models but in my sales I have 6 models. Part of the formula is to calculate the count of claims and divide it by Total sales. Which is not producing the right results as counts are for 4 models from claims but we are diving it sales total of 6 models.=

---

What does 4 models and 6 models mean? In the sample you post, there're 7 tables and one page report. Could you clarify more details about the logic and show the expected result?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mukhan169]

@v-yuta-msft 

If you look in the claims file. You have NP0, NQF, NQG and NQH models that have claims. Its the "model" field in claims table.
But if you look at sales converted data under "Model" field It will show NP0.NQ^,NQ&,NQF,NQG and NQH. So when I run the Sales sum it sum all the models that are in the sales and return the number I just want the total of sales from sales for only the models that are in claims table.

Thanks in advance for your help.

[mukhan169]

Anyone can help in this regard?

[mukhan169]

As you can see that total claims only have 4 models but it is calculating sum of sales for 6 for total sales.

Any help will be greatly appriciated.

[HotChilli]

I don't think you've attached the correct file in the first post.  All tables only have one model 'JK'

[mukhan169]

Correct Modeling file

Thank you, was probably having a brain fart. Thank you for pointing it out.

[HotChilli]

You will have to create a visual by using the Models table since it links Claims and Sales.

There is a problem with this table because it doesn't have 'NQH' model.

[mukhan169]

@HotChilli  Thank you . I am not sure how to create the measure for sales that only sum all the models in sales For the models claim have.  Here is the latest file again. THank you for pointing out the silly mistakes, its unfortunate I cant share the real data I have to create dummy data.

Models Fixed