Forum Discussion
Adding Multiple Total Columns to a Matrix
New to Power Bi. Can find similiar queries, but the basic set up of the raw data is different so i can't seem to make the responses work. So i have my raw data that is imported which looks like this...
The best first step for you is to create some measures. Assuming your data table is called 'RawData':
Total True = SUM('RawData'[RANGE])
Total False = COUNTROWS('RawData')-[Total True]
Percent = DIVIDE([Total True],[Total True]+[Total False])
Once you've created these 3 measures, I think the best solution for you is to create two visuals. One matrix showing product by site, as you have it already, and another just showing the totals and percentages, using the measures you've just created. I cannot think of a way of doing what you want in one visual.