Filter data based on a table

[Anonymous]

Hi,

One short question about two databases in a table

1. Table 1 - premium per client (more than 10.000 clients)

2. Table 2 - payments per client (500 payments)

First of all, I created a separate table with the distinct beneficiaries and relationships with the two tables presented above.

Then I was trying to see the clients with payments and also the premiums issued only for this clients.

When I add the data there appears all the clients with premium. I wanna filter only the clients with payments.

I do not want to do this from the filter (with payments greater than 0). I wanna use a DAX formula or something.

Thanks in advance.

[v-yingjl]

Hi @Anonymous ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[Ashish_Mathur]

Hi,

Share some data that can be pasted in an Excel workbook and also show the expected result.

[v-yingjl]

Hi @Anonymous ,

I have created a table visual like this:

If I got it correctly, you want to filter the row E which payment is not blank or greater than 0, right?

If so, create this control measure, set its value as 1 in the visual filter:

Measure = 
IF ( NOT ( ISBLANK ( SUM ( Table2[Payments per client] ) ) ), 1, 0 )

Attached my sample file that hopes to help you: filter data based on a table.pbix

Best Regards,
Yingjie Li

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

[amitchandak]

@Anonymous , hope you already have a common client table. with that, you can use visual level filter or create a filter on countx

You can change condition

countx(filter(Values(client[client]),[payment] > 0 && [premium] >0 ),client[client])