How to calculate Percentage in Values are present in both the tables

[Mavericks334]

Hi,

I have 5 tables. Date Table, Raw data table, States Table, Clients Table, Type of Tasks. Below are the columns for each table.

Raw data table and Client Table are related with Date Table and States Table, Type of Tasks.

State ID Task Type IDs Completed Month End Date
1 A 5 2/18/2016
1 B 6 2/19/2016
3 A 10 2/20/2016
3 A 10 2/21/2016
1 A 15 2/22/2016
1 B 26 2/23/2016

State ID No of Clients Task Type Month End Date
1 25 A 2/29/2016
1 25 B 2/29/2016
1 25 C 2/29/2016
2 45 A 2/29/2016
2 50 B 2/29/2016
2 75 C 2/29/2016
3 40 A 2/29/2016
3 35 B 2/29/2016
3 60 C 2/29/2016



I would Like to get percent for the task. Where the calculation needs to be take in to consideration only if that particular state id has value in the raw data table.

Any suggestions how it could be achieved.

Regards,
Renato.

 

[Mavericks334]

I tired this as a calculated column and have been abel to get my results that i need. =IF(SUMX('RAW',FIND(UPPER([FREQU_CONCA]),UPPER(RAW[RAW_FREQ_CONC]),,0))>0,1,0).

FREQU_CONCA & RAW_FREQ_CONC- Concatenating the common fields.

Regards,
Renato.