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 want to create measure in the table "TAB_1", which sums up tle values "VALUES" from the table "TAB_2" only then if in the table "TAB_2" appears "cont_id" bigger than 0. I enclose screencast of my model. In my opinion, I have to activate inactive relationships. These relationships must be inactive in the model. I have now created something like this:
Values = CALCULATE(sum(TAB_2[VALUES]); USERELATIONSHIP(TAB_1[TAB1_id];TAB_2[TAB2_id]); TAB_2[cont_id]>0; USERELATIONSHIP(TAB_1[date];TAB_DATE[date]))
Unfortunately, this measure sums up everything from "VALUES" and it doesn't work on date filters.
Hi @nice_boy,
Based on my test, the above measure you provided works fine to generate the sum value. Below is the result in my test. I used a card visual to display the measure value.
In your scenario, what visualization did you use? Please show us the current output which does not meet your requirement.
Regards,
Yuliana Gu
Unfortunately still not working date filter
Change the link between the date table and Tab_1 to be Both directions.
I changed it but did not change
There must be something else at play here thats bigger than what is presented. It would be worth double checking your date slicers and making sure they come from one of those 3 tables.
To me it looks like you are overcompliating the measure itself. You already have the table relationships so just try this simple measure:
Values = CALCULATE( sum(TAB_2[VALUES]), TAB_2[cont_id] > 0 )
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |