Forum Discussion

smjoshi's avatar
smjoshi
Frequent Visitor
4 years ago
Solved

Need help in this matrix visual

Hello  I have Table 1 as input data. Table thrid is final outut table. I'm able to dervie till table 2 only. Need help how to dervie table 3 in simple way  Table 1 Bundle ID Case ID 4000 1...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, smjoshi 

     

    You can try the following methods.

    Calculated column:

    Count of Case ID per bundle =
CALCULATE (
    COUNT ( 'Table'[Bundle ID] ),
    FILTER ( 'Table', [Bundle ID] = EARLIER ( 'Table'[Bundle ID] ) )
)

    Count of bundle ID with  count of caseIDS =
DIVIDE (
    CALCULATE (
        COUNT ( 'Table'[Count of Case ID per bundle] ),
        FILTER (
            'Table',
            [Count of Case ID per bundle] = EARLIER ( 'Table'[Count of Case ID per bundle] )
        )
    ),
    [Count of Case ID per bundle]
)

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, smjoshi 

 

You can try the following methods.

Calculated column:

Count of Case ID per bundle =
CALCULATE (
    COUNT ( 'Table'[Bundle ID] ),
    FILTER ( 'Table', [Bundle ID] = EARLIER ( 'Table'[Bundle ID] ) )
)

Count of bundle ID with  count of caseIDS =
DIVIDE (
    CALCULATE (
        COUNT ( 'Table'[Count of Case ID per bundle] ),
        FILTER (
            'Table',
            [Count of Case ID per bundle] = EARLIER ( 'Table'[Count of Case ID per bundle] )
        )
    ),
    [Count of Case ID per bundle]
)

 

Best Regards,

Community Support Team _Charlotte

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