Forum Discussion
Calculating a KPI based on value displayed in two visuals
Community SupportHi sfagan55
Do you mean you'd like to apply the addition/subtraction/multiplication/division on several visuals separately?
You might check with the what-if parameter:
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
I should have started by saying that the visuals are both tables. Column A in each identifies the type of defect, while Column B in Visual 1 displays the total number of inspections for that type of defect, while Column B in Visual 2 displays the total occurences of defect. There aren't any filters in Visual 1 because I need the total quantity of inspections performed. There are multiple filters on Visual 2 because it displays first pass yield. If I apply the same filters to both visuals, then my total quantity inspected reduces to only the inspections where defects were discovered (because with the filters and links between tables defined, that's all it can recognize). The number I need is the value in Column B of Visual 2 divided by the value in Column B of Visual 1 (defectives as a percent of total inspections). I don't need the math to span multiple visuals, just to give me an aggregate value of the two visuals.
Thank you both for your assistance and I apologize I can't share the visual; it has proprietary data in it at the moment. If I can strip it out, I'll share something.