Issue with data model

[Dunner2020]

Hi there,

I have created a measure which multiplies the no of the customer of different type and the price customer want to pay w.r.t season of the year and time of the day.

WTP =
Var _agri = CALCULATE([WTP Agr] * [Agricultural])
Var _com = [WTP Com] * [Commercial]
Var _ind = [WTP Ind] * [Industrial]
Var _res = [WTP Res] * [Residential]
RETURN
_agri + _com + _ind + _res

However, I noticed that when I select the season the year from slicer it gives the same value for the all time of the day for the season. I am not sure where am I making the mistake. Whether its data model or problem in dax calculation. Any help in fixing the issue would be really appreciated. Sample here

[aj1973 · Accepted solution]

Hi @Dunner2020 

Your Model doesn't make any sens

Your tables are either related randomly or not related, you are calling to filter on Time table while Time Table is not related to any tabel, Many to many....

Building a report starts in Power Query to Modeling to reporting to publishing. 

Good luck

[VijayP]

@Dunner2020  Need to know the reason for using CALCUALTE in the first Varibale. May be that is causing issue! Less information but just assuming based on your explanation! Sharing some data helps!'