Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX issue

I ran into the situation while trying to automate all the manual entry values in measures. I have created table in DB as mentioned below.   Table Name :Demo Column Value Company Microsoft ...
Need Help
DataInsights's avatar
DataInsights
Super User
5 years ago

Anonymous,

 

Try the following:

 

1. Create a relationship between the Demo and Summary tables:

 

 

2. Create the measure below:

 

Balance = CALCULATE ( SUM ( Summary[Available] ), Demo[Column] = "Id" )