Calculating percentage from two different tables in power bi desktop

[lukaspowerbi]

I am trying to create a card visual displaying a percentage number that is derived from two tables. 

Table 1 Sample:

Table 2 Sample:

How can I accomplish the following:

Table1(Member ID) divided by Table2(Member ID) *100 = 45%

This is just an example %number but I would like to see the % number in my card visual. 

[srinivt · Accepted solution]

You can write DAX measure to do that. However, your example and usecase seems to be a bit confusing, because, for a card visual you are looking at a single number for the entire table. One way to achieve that is to aggregate the data from each table, but I am not sure if that is what you want. In any case here is a sample DAX measure for that: SUM(Table1[MemberID]) / SUM(Table2[MemberID]). 

[lukaspowerbi · Accepted solution]

Thanks @srinivt

Yes, I am looking for a single number. 

[v-yuezhe-msft]

@lukaspowerbi,

Have you got expected result after you creating a measure as srinivt's post?

Regards,
Lydia

[srinivt · Accepted solution]

You can write DAX measure to do that. However, your example and usecase seems to be a bit confusing, because, for a card visual you are looking at a single number for the entire table. One way to achieve that is to aggregate the data from each table, but I am not sure if that is what you want. In any case here is a sample DAX measure for that: SUM(Table1[MemberID]) / SUM(Table2[MemberID]).