Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
We have a client database that has a main client ID with nested Sub client IDs
EX: 123456.0000
123456 = Main Client
.0000 = Sub Client
123456.0000 = Main Client
123456.0001 = Sub Client 1
123456.0002 = Sub Client 2
123456.0003 = Sub Client 4
Some Sub Clients have referrals but most do not
We are looking for an IF statement or something similar to show the main client number with all the sub clients even if only one sub client has a referral.
Client ID SubID Referral Total Revenue
123456 .0000 2000
123456 .0001 Jim 1000
123456 .0002 3000
123456 .0003 4000
In this example we would like to show all 4 of these clients because sub ID .0001 has a referral, but if the referral column was blank for all of the clients in the related client ID of 123456 we would like to hide them so they do not get included in the total revenue generated by referrals.
Hi @melaniemdavis ,
If the column of "Total Revenue" is created by formulas, you could add filters to exclude the data which is without Referral. For your requirement about hide the Client ID when there is no data of Referral, it is impossible. We just can set to blank values. The name of "Client ID" will still be shown in the visual.
If I understand incorrectly, please point out.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.