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 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