Forum Discussion
Vizualization : Card
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.
You may use a measure instead.
Measure = DIVIDE ( SUM ( Table1[NPV] ), SUM ( Table1[Initial Investment] ) )
2 Replies
- v-chuncz-msftCommunity Support
You may use a measure instead.
Measure = DIVIDE ( SUM ( Table1[NPV] ), SUM ( Table1[Initial Investment] ) )
- AlejandroJ92New Member
Thank you!