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. 

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

Hi nigama  seems like you have some issues with table relationships. Here is some way to identify the issue 

 

Solution 1: Update your measure with this 

My Measure = 
var result = [actual measure]
RETURN
    IF(ISBLANK(Result), 0, Result)

Solution 2: Click the matrix visual and ensure for each rows and columns has "Show items with no data" enabled. 

 

Test this and let us know, if you can share your power bi file with some sample data it will be a quick fix. 

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

 

  • 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