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, I have a few date fields in my fact table. I created a date dimension table and assigned all the relationships to them.
I Know only one will be active out of all. ( pic is shown below).
Can someone help me in calculating a running total column using a different relationship?
Below is one Calculated column I created ( which is working since I used this with an active relationship.
Now I want to create one more running total.(Using the date Hos
Below is what I have ( this is now working).
Thank you.
Solved! Go to Solution.
Below is how I got what I needed.
Thank you all for your help.
I really Love this community.
is second either use all(Date) or use crossfilter (option none) to remove join with the other date
Tough to be specific, but in general you need to use USERELATIONSHIP.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thank you for trying to help me.
I used this below expression to calculate and still I am not getting what I needed.
Any help is really appreciated.
Hi, @reddy421_hc
Based on your description, I created data to reproduce your scenario.
TableA:
TableB:
The relationship between two tables is inactive.
You may create a measure as below. It is important that you should write 'USERELATIONSHIP(TableB[UserId],TableA[UserId])' instead of 'USERELATIONSHIP(TableA[UserId],TableB[UserId])'
Measure =
CALCULATE(
SUM(TableB[Amount]),
USERELATIONSHIP(TableB[UserId],TableA[UserId])
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Below is how I got what I needed.
Thank you all for your help.
I really Love this community.
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |