Help combining Date and Type

[Karaduz]

Hello,

My Current Data                                 What I want it to look like

Month      Issue      Time Spent Jan            A            1 Jan            A             .5 Jan            B             1 Feb           A             2 Feb           B              1 March       B              3 March       B              1.5 March       C               2

Issue      Jan         Feb     March A            1.5           2           0         B             1              1          4.5  C             0              0            2

When I put the tables together my results come out like this:

Issue      Jan         Feb     March

A            2.5           2.5       2.5       

B             6.5         6.5         6.5 

C             2              2            2               

Can someone explain what I am doing wrong?

[V-lianl-msft]

Hi @Karaduz ,

Please check whether the relationships between the tables are correct. If "time spend" is a measure, it may also calculate the wrong answer in this matrix.

See if you can share the sample pbix or image of the data model.(Please mask any sensitive data before uploading)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Karaduz]

@V-lianl-msft  @amitchandak 

I've attached the model.

[amitchandak]

Is Month of the issue taken from some other table for display.  This seems like a missing join issue. Should not be there if you are using same table

[Karaduz]

Month is taken from a whole other table. There is a total of three different tables within this scenario.

Would they all have to be joined together?

[amitchandak]

make sure, either table are joined or joined to common dimension

[amitchandak]

@Karaduz , did you able to resolve the issue or need more help. If so mark me @