Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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,
Have you got expected result after you creating a measure as srinivt's post?
Regards,
Lydia
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]).
User | Count |
---|---|
106 | |
86 | |
81 | |
74 | |
71 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |