Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a column which is budget amount coming from budget table. There is a relationship exists between budget and orders via product and when I use that column inside fact orders, I am not getting row level data (I am expecting atleast same values if relationship issue ) but total is showing correct value
Solved! Go to Solution.
Hello @sathishdgl,
Here are some suggestions that might help to troubleshoot this issue:
Check Relationships: Verify that the relationships between the relevant tables (such as 'Budget', 'Orders', and 'Product') are correctly set up. Make sure the columns used for relationships have matching data types and contain common values.
Check Context and Filters: Pay attention to the context and filters applied to your visuals. If a visual is not displaying row-level data as expected, it might be due to filters or slicers that are affecting the context. Clear filters or slicers that might be altering the view.
Evaluate DAX Measures: If you're using DAX measures in your visuals, review them carefully. A DAX measure might be aggregating data differently than you expect, which could lead to discrepancies between row-level data and totals.
Use CALCULATE to Modify Context: Use the CALCULATE function to modify the context in your DAX measures if necessary. This function allows you to apply filters and change context to ensure the correct calculations are performed.
Should you require further assistance, please do not hesitate to reach out to me.
Hello @sathishdgl,
Here are some suggestions that might help to troubleshoot this issue:
Check Relationships: Verify that the relationships between the relevant tables (such as 'Budget', 'Orders', and 'Product') are correctly set up. Make sure the columns used for relationships have matching data types and contain common values.
Check Context and Filters: Pay attention to the context and filters applied to your visuals. If a visual is not displaying row-level data as expected, it might be due to filters or slicers that are affecting the context. Clear filters or slicers that might be altering the view.
Evaluate DAX Measures: If you're using DAX measures in your visuals, review them carefully. A DAX measure might be aggregating data differently than you expect, which could lead to discrepancies between row-level data and totals.
Use CALCULATE to Modify Context: Use the CALCULATE function to modify the context in your DAX measures if necessary. This function allows you to apply filters and change context to ensure the correct calculations are performed.
Should you require further assistance, please do not hesitate to reach out to me.
User | Count |
---|---|
21 | |
20 | |
12 | |
10 | |
8 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |