Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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!