Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I have a small puzzle I am trying to understand. I have a relational database where GLs are attributed to products and services.
Here is the model I have so far, and the relationships I have modeled:
The best I can do with this setup is the following visual:
Since the balances for products and services are not on the same table, I cannot select them into the same column aligned with their respective GLs. Is there a way I can create a measure that will put these calculations into the same column?
What I have tried so far:
Here I attempted to see if it would only show the sum across the products and not the services. But it bloated everything instead.
I am looking for something like:
Is there a way I can accomplish this with a DAX measure? or is there some alternative method I can try in the model?
*I would like to keep the product and service tables seperate from one another
*I would like to attach the .pbix file with the model already in it, but I don't know how.
UPDATE:
I can get it to do exactly what I want in DAX Studio, but the DAX query does not have the same output in the desktop application.
Thank you!
Solved! Go to Solution.
The filter context was activated in DAX Studio because the table argument was explicitly defined in the query. In Desktop it is not. Thus:
CALCULATE(SUM('Product'[Balance])+SUM('Service'[Balance]),'glFactTable')
Will work in PBI Desktop.
Thank you me!
Your Welcome.. Me.
The filter context was activated in DAX Studio because the table argument was explicitly defined in the query. In Desktop it is not. Thus:
CALCULATE(SUM('Product'[Balance])+SUM('Service'[Balance]),'glFactTable')
Will work in PBI Desktop.
Thank you me!
Your Welcome.. Me.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |