0
0
Figmabi_tool~10 mins

Community resources and templates in Figma - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table lists popular community resources and templates for Power BI users to learn, share, and accelerate report building.

CellValue
A1Resource Name
B1Type
C1Description
D1Link
A2Power BI Community
B2Forum
C2Official Microsoft Power BI user forum for questions and sharing.
D2https://community.powerbi.com/
A3Power BI Templates
B3Templates
C3Pre-built Power BI report templates for quick start.
D3https://powerbi.microsoft.com/en-us/templates/
A4DAX Guide
B4Documentation
C4Comprehensive guide to DAX functions and formulas.
D4https://dax.guide/
A5Power BI Showcase
B5Examples
C5Gallery of reports and dashboards created by the community.
D5https://community.powerbi.com/t5/Data-Stories-Gallery/bd-p/DataStoriesGallery
Formula Trace
COUNTROWS(FILTER(sample_data, sample_data[Type] = "Templates"))
Step 1: FILTER(sample_data, sample_data[Type] = "Templates")
Step 2: COUNTROWS([Row 3])
Cell Reference Map
    A               B           C                                   D
1 | Resource Name | Type      | Description                       | Link
2 | Power BI Community | Forum     | Official Microsoft Power BI... | https://community.powerbi.com/
3 | Power BI Templates | Templates | Pre-built Power BI report...  | https://powerbi.microsoft.com/en-us/templates/
4 | DAX Guide          | Documentation | Comprehensive guide to DAX... | https://dax.guide/
5 | Power BI Showcase  | Examples  | Gallery of reports and dash... | https://community.powerbi.com/t5/Data-Stories-Gallery/bd-p/DataStoriesGallery

Arrows: Formula filters on column B (Type) for 'Templates' in row 3.
The formula references the 'Type' column in the sample data to filter rows where Type is 'Templates'. Only row 3 matches this condition.
Result
    A               B           C                                   D
1 | Resource Name | Type      | Description                       | Link
2 | Power BI Community | Forum     | Official Microsoft Power BI... | https://community.powerbi.com/
3 | Power BI Templates | Templates | Pre-built Power BI report...  | https://powerbi.microsoft.com/en-us/templates/
4 | DAX Guide          | Documentation | Comprehensive guide to DAX... | https://dax.guide/
5 | Power BI Showcase  | Examples  | Gallery of reports and dash... | https://community.powerbi.com/t5/Data-Stories-Gallery/bd-p/DataStoriesGallery

Result: 1 (There is 1 template resource in the list)
The final result of the formula is 1, indicating there is one resource of type 'Templates' in the sample data.
Sheet Trace Quiz - 3 Questions
Test your understanding
How many resources in the sample data are of type 'Templates'?
A2
B3
C1
D0
Key Result
COUNTROWS(FILTER(table, table[column] = "value")) counts rows matching a condition.