Forum Discussion

nigama's avatar
nigama
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Power BI Matrix Not Showing Values for All Category-Group Combinations

What I'm Trying to Do I have a table called EntityAssignments that tracks where each entity is assigned.   EntityAssignments has these fields:   EntityID Name Group Category SubLocation I ...
Need Help
  • nigama's avatar
    nigama
    1 year ago

    Thank you v-pnaroju-msft and Royel 

    I was able to resolve the issue but switching my dimension tables to dual mode(import mode works too). 
    A possible explaination I found for this is that, in DirectQuery Many to Many relationships  generate complex subqueries for power BI and since my fact table right now have Many to many relations with my dimension tables, I have this issue. I am still looking into a detailed understanding of the behaviour. 

nigama's avatar
nigama
Icon for Advocate I rankAdvocate I
1 year ago

When I try solution 1 , I get zeroes in all the cells but the totals row at the bottom behaves as expected.
I have implemented solution 2 either but it doesnt work as well. 

Unfortunatley I cannot share the file due to org policies. 

Royel's avatar
Royel
Icon for Super User rankSuper User
1 year ago

nigama  you are getting 0 that means the combination you are going to display the value are returning blanks. So, there is a very high possiblity you have issue with table relationships and DAX are not well written to return results. 

 

Todo:

1. Verify your table relationships 

2. Update dax for measure

3. Try to validate your dax with a single items data where you know, there should be some data. 

 

Thanks