Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |