Forum Discussion
visual matrix
That sample data is not usable.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
| Time Frame | 0 | ||||||||
| Property Name | Position | Manager | Assistant | Leasing | Leasing | Leasing | Leasing | ||
| Task | Position Specific Requirements | Total | Name | Individual Scores | |||||
| Move ins per 30 days | Average number of move ins per 30 days based on quarterly total | -0.33 This Cell Total Has formula =(1-Count('Move ins Per Agent'!C:C))/-3 | =COUNTIF('Move Ins per Agent'!D:D,"*"&D3&"*")/3 | =COUNTIF('Move Ins per Agent'!D:D,"*"&E3&"*")/3 | =COUNTIF('Move Ins per Agent'!D:D,"*"&F3&"*")/3 | =COUNTIF('Move Ins per Agent'!D:D,"*"&G3&"*")/3 | =COUNTIF('Move Ins per Agent'!D:D,"*"&H3&"*")/3 | =COUNTIF('Move Ins per Agent'!D:D,"*"&I3&"*")/3 | =COUNTIF('Move Ins per Agent'!D:D,"*"&I3&"*")/3 |
| Percent of Move Ins Per Site | -0.33 This Cell Total Has formula =(1-Count('Move ins Per Agent'!C:C))/-3 | =IFERROR(D5/C5,"0.00%") | =IFERROR(D5/C5,"0.00%" | =IFERROR(D5/C5,"0.00%" | =IFERROR(D5/C5,"0.00%" | =IFERROR(D5/C5,"0.00%" | =IFERROR(D5/C5,"0.00%" | =IFERROR(D5/C5,"0.00%" | |
| Closing Ratio | New Lead Conversions | ||||||||
| First Visit/Tour Conversion | |||||||||
| JTurner | Number of Prospect Survey Scores | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$C:$C,B2),"0") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,'Summary Table'!$D3),"0") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,'Summary Table'!$D3),"0") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,'Summary Table'!$D3),"0") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,'Summary Table'!$D3),"0") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,'Summary Table'!$D3),"0") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,'Summary Table'!$D3),"0") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,'Summary Table'!$D3),"0") |
| Prospect Survey Average Score | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$C:$C:$C,B2,JTURNER DASHBOARD'!$G:$G),"0.00") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,Summary Table'!D3',JTurner Dashboard'!$G:$G), "0.00") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,Summary Table'!D3',JTurner Dashboard'!$G:$G), "0.00") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,Summary Table'!D3',JTurner Dashboard'!$G:$G), "0.00") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,Summary Table'!D3',JTurner Dashboard'!$G:$G), "0.00") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,Summary Table'!D3',JTurner Dashboard'!$G:$G), "0.00") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,Summary Table'!D3',JTurner Dashboard'!$G:$G), "0.00") | =IFERROR(COUNTIF('JTURNER DASHBOARD'!$D:$D,Summary Table'!D3',JTurner Dashboard'!$G:$G), "0.00") | |
| Shopping Report Score | Expect 90% total score in order to not be reshopped and write letter to Jim | =AVERAGE(D11:|11) | |||||||
| Online Reviews (in JTurner) | Number of online reviews NAMED in vs total reviews for site. | =COUNTIF('JTurner Rating '!$D:$D,$B2) | =COUNTIF('JTURNER RATING'!$G:$G,"*"&D3&"*") | =COUNTIF('JTURNER RATING'!$G:$G,"*"&D3&"*") | =COUNTIF('JTURNER RATING'!$G:$G,"*"&D3&"*") | =COUNTIF('JTURNER RATING'!$G:$G,"*"&D3&"*") | =COUNTIF('JTURNER RATING'!$G:$G,"*"&D3&"*") | =COUNTIF('JTURNER RATING'!$G:$G,"*"&D3&"*") | =COUNTIF('JTURNER RATING'!$G:$G,"*"&D3&"*") |
| Percent of Reviews for sites | =COUNTIF('JTURNER RATING'!$D:$D,$B2) |
Hello lbendlin
This is the table how i use as summary table the data value comefrom diffrent sheets.
You seem to be referencing at least three other tables.