Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Matrix not displaying all values while still counting them in totals

i everybody,   I'm currently working on a report involving timeregistration, which involves files with entries for time off measured in hours. I display these in a matrix, and have three slicers (y...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Please check out the file in the attachment. I have made some changes. Now you will have a model with best practices. I will check more to find out why. Please follow my adjustments for now.

    1. Create a new table. 

    FullNames =
DISTINCT (
    UNION ( VALUES ( Timesheets[Full name] ), VALUES ( Vakantiedagen[Full name] ) )
)

    2. Delete the *:* relationship and create new ones. 

    3. Use the new column from the new table in a slicer instead. 

    Matrix_not_displaying_all_values_while_still_counting_them_in_totals

     

    One tip: Don't upload sensitive data here.

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

Please share the file or a dummy one which can reproduce the issue. Just see from your information here, that's impossible. We need to check the data and its structure of the model. 

 

Best Regards,

Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Dale,

 

I added a link to the file in my post. Thanks in advance for looking, this is driving me absolutely cray-zee.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

     

    Please check out the file in the attachment. I have made some changes. Now you will have a model with best practices. I will check more to find out why. Please follow my adjustments for now.

    1. Create a new table. 

    FullNames =
DISTINCT (
    UNION ( VALUES ( Timesheets[Full name] ), VALUES ( Vakantiedagen[Full name] ) )
)

    2. Delete the *:* relationship and create new ones. 

    3. Use the new column from the new table in a slicer instead. 

    Matrix_not_displaying_all_values_while_still_counting_them_in_totals

     

    One tip: Don't upload sensitive data here.

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for the information. I removed the PI in there, but have removed the uploaded file as well. You can remove your attached file. Again, thanks!

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        I'm glad it helped. It's my pleasure. Anonymous. The file was deleted. You can send the link through Message next time. 

         

        Best Regards,

        Dale