Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
This is probably a rookie mistake and I searched through some similar examples but could not figure out how to make this work. I created a mini subset of my data and dashboard and included a link to my .pbix file below.
Thanks for any help you can provide!
A couple of mistakes:
1. Buyer Table - PO Target Variance is wrong (the Total is wrong and the total for Buyer 5 should be zero)
2. Card for PO Target Variance (to the right of the buyer table) is wrong - $113.01 - it should be $31.21
3. Detail Table - should not be showing blank rows and the total amount of PO Target Variance is wrong (similar to issues above)
Measures I used:
Here is a link to my .pbix:
https://drive.google.com/file/d/1oo2pgJKbKUhUkSUR9tYikjJIluOGb8d2/view?usp=sharing
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
May be this is relationship issue.
Please use "Cross Filter direction" option as both as shown in the screen.
Output:
download the file from here:
https://drive.google.com/open?id=1PSIV4FZd-85D6LdMYEJ4kRzL2u0BQRMl
Hi,
You may download my PBI file from here.
Hope this helps.
I like how you solved that - many thanks!
Hi,
Please select correct answer. So that people can understand easily.
You are welcome.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |