Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |