Matrix columns

[JMquade]

Hello! 

I am new to PBI and I am wanting to create a matrix table that shows a percentage if stores created an account. 

I think my issue is that the data I have is not numerical, in the raw data it shows as 'created' or 'not created' and usually in excel I can create a pivot and just copy the part I need. My issue is that when I filter for 'created' value PBI will make the created column values 100%. Is there a way to merge these to only show the created column? 

Eventually, I would like to add the another column '% created in system a' so that it is all on the same table.

This is an example of what I have currently. 

Store Name	Created	Not Created
X	92.50%	7.50%
Y	94.44%	5.56%
Z	90.91%	9.09%

This is what I want to create. 

Store Name	% Created	% Created in system A
X	92.50%	97.80%
Y	94.44%	96.00%
Z	90.91%	98.36%

[JMquade]

Figured this out. 

The data I had contained a column called created status which had text values in it, either 'created' or 'not created' 

When I previously tried to put this coulmn in a matrix it would make a seperate column for 'created' and 'not created' and I used an index coulmn to do a count and show as percentage. 

My issue was that I only wanted the created column to be seen but when I would filter for creatred it would change the percentages in the column to 100%. 

The fix:

I created a conditional column where 'created' = 1, else 0. 

Then created a measure 

Measure = DIVIDE(SUM('Table name'[conditional column]),COUNTA('Table Name'[conditional column]))

I used this measure in the matrix with the store names as my rows. Make sure you format how you want the measure to look (e.g percentage, whole number etc.) 😊

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

[JMquade]

When I add the created status to the coulmns section, it will split into two columns 'created' and 'not created'.

The first example above I had the created status in the columns section and an index column in the values section. I changed the index value to be count of and then changed it to show as percentage of rows which brings up the correct percentages. 

I have also gotten the same outcome by using the creation status in both the columns and values sections and changing the values to the same, percentage of row total count of creation status. 

Is there a way to have just the 'created' column in the matrix show? If I filter to only show the created percentage it changes the percentages. 

I have also tried adding in measures but I am still understanding how these work. When I try to add the creation status in measures, an error will say unable to calculation value of creation status. 

Would I have to create multiple measures to essentially say "count the amount of times 'created' shows in the raw data column creation status"? 

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...