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.
Hi,
I'm building a report in Power BI Desktop. I have an index (profittability index) in a column result from a division between 2 columns (NPV and Initial Investment) in the main page. In this page, I have some slicers that allowed me to see projects by status or area, also I have a card that shows me the index that i mentioned. If I select one of the projects, the index in the card is OK, but when I don't select any, It only display the sum (or any of the basic operators the card supports e.g. avg, max, min, etc.) of the index of all the projects. I want to know if there's a way that the card can display the index result of the sum of all the NPV by the sum of all the initial investment of all the projects, and when I filter by the slicer it display the index result of the sum of the NPV of all the selected projects by the sum of the initial investment of all the selected projects.
Hope you can help me. Regards.
Solved! Go to Solution.
You may use a measure instead.
Measure = DIVIDE ( SUM ( Table1[NPV] ), SUM ( Table1[Initial Investment] ) )
You may use a measure instead.
Measure = DIVIDE ( SUM ( Table1[NPV] ), SUM ( Table1[Initial Investment] ) )
Thank you!
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |