Forum Discussion

Amerivike's avatar
Amerivike
Advocate II
5 years ago

Segmenting Like Data From the Same Column in a Table

My fact table: 

AccountContractContract Type
Account 1ExclusiveRecommended
Account 1EnhancedCurrent
Account 2BalancedRecommended
Account 2EnhancedCurrent
Account 3EnhancedRecommended
Account 3BalancedCurrent
Account 4EnhancedRecommended
Account 4EnhancedCurrent
Account 5BalancedRecommended
Account 5EnhancedCurrent
Account 6EnhancedRecommended
Account 6CashCurrent
Account 7BalancedRecommended
Account 7CashCurrent

 

I need a table that looks like this:

Recommended ContractCount of RecommendedCount of CurrentCount of Current BalancedCount of Current CashCount of Current Enhanced
Exclusive10001
Balanced31012
Enhanced34111

I don't have issues calculating Columns B&C, but the "Count of Current" measures give me problems. Column A has to be the Recommended contracts so the entire table is in the context of recommended contracts. When I try to build my table measures out, the results are incorrect.

 

Any counsel is super appreciated!

Need Help

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi Amerivike ,

     

    Not understandnig how you are maknig the transaction of the values from one column to the other in your  Contract you have 4 values however in the table above you only have 3 (cash is transformed to the contract type) then you show also the count of balanced with Cash and ehanced with cahs and balanced but there is no data like that.

     

    Can you explain a little bit better how you get to the result you are showing?

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    5 years ago

    Hi, Amerivike 

    What are your calculation logic for the last three columns?

     

     

     

    According to the titles of the rows and columns you provided, I get the following result.

     

    or

     

     

     

    Here is the sample.

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.