Forum Discussion
Issue with data model
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
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
2 Replies
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!'
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
