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 have Table A that has a “Name” column (text format), “DateTime” column (datetime format), “Window” column (text format) and an “Emails Received” column (integer). The “Window” column has many options including “4PM”, “5PM”, “6PM”, etc. I have created two cards with filters on them. One titled (say Card A) “Total count of distinct names that can receive emails for timeframe” that counts distinct names for multiple selected “DateTime” AND multiple selected “Window” no matter the email count. The other card (Card B) is titled “Total count of distinct names that received emails for timeframe” that counts distinct names for multiple selected “DateTime” AND multiple selected “Window” with email counts NOT 0. So far so good? These two cards work fine for me. But now I need a third card (Card C) based on these two. The formula would be (Card A – Card B)/Card A. I do not know how to create a measure to do this. I would then want Card C to be the outcome of the measure. I tried doing it based on what I found in the Power BI forums but they fail and do not produce a number. I am not sure how to incorporate the filters into a measure either. Can anyone help me? Or am I making this way too complicated and should be doing this a different way altogether?
Solved! Go to Solution.
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 |
---|---|
109 | |
108 | |
88 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |