MindMap Gallery PowerBI.DAX
Suitable for those with basic knowledge, including aggregation operations, Proportion calculation, Ranking calculation, grouping problems, Time dependent etc.
Edited at 2023-12-14 17:41:16This Valentine's Day brand marketing handbook provides businesses with five practical models, covering everything from creating offline experiences to driving online engagement. Whether you're a shopping mall, restaurant, or online brand, you'll find a suitable strategy: each model includes clear objectives and industry-specific guidelines, helping brands transform traffic into real sales and lasting emotional connections during this romantic season.
This Valentine's Day map illustrates love through 30 romantic possibilities, from the vintage charm of "handwritten love letters" to the urban landscape of "rooftop sunsets," from the tactile experience of a "pottery workshop" to the leisurely moments of "wine tasting at a vineyard"—offering a unique sense of occasion for every couple. Whether it's cozy, experiential, or luxurious, love always finds the most fitting expression. May you all find the perfect atmosphere for your love story.
The ice hockey schedule for the Milano Cortina 2026 Winter Olympics, featuring preliminary rounds, quarterfinals, and medal matches for both men's and women's tournaments from February 5–22. All game times are listed in Eastern Standard Time (EST).
This Valentine's Day brand marketing handbook provides businesses with five practical models, covering everything from creating offline experiences to driving online engagement. Whether you're a shopping mall, restaurant, or online brand, you'll find a suitable strategy: each model includes clear objectives and industry-specific guidelines, helping brands transform traffic into real sales and lasting emotional connections during this romantic season.
This Valentine's Day map illustrates love through 30 romantic possibilities, from the vintage charm of "handwritten love letters" to the urban landscape of "rooftop sunsets," from the tactile experience of a "pottery workshop" to the leisurely moments of "wine tasting at a vineyard"—offering a unique sense of occasion for every couple. Whether it's cozy, experiential, or luxurious, love always finds the most fitting expression. May you all find the perfect atmosphere for your love story.
The ice hockey schedule for the Milano Cortina 2026 Winter Olympics, featuring preliminary rounds, quarterfinals, and medal matches for both men's and women's tournaments from February 5–22. All game times are listed in Eastern Standard Time (EST).
DAX
Aggregation operation
polymerization
SUM/AVERAGE: can only aggregate numerical values
MAX/MIN: Text can be aggregated
count
DISTINCTCOUNT: Distinct counting
COUNTROWS: Count the number of rows in the table
COUNTROWS(VALUES()): Unrepeated counting
condition count
CALCULATE( COUNTROWS(), FILTER(table, condition) )
average value
AVERAGE
AVERAGE(table[column])
AVERAGEX
AVERAGEX(table, table[column])
Common writing method
AVERAGEX( VALUES (calculated dimension column), [Calculated by measure] )
AVERAGEX( VALUES (calculated dimension column), CALCULATE(SUM(table[column])) )
Proportion calculation
Overall proportion
Overall proportion
DIVIDE (numerator, denominator)
DIVIDE( [Sales], CALCULATE( [Sales], ALL('Product table') ) )
Group proportion
DIVIDE( [Sales], CALCULATE( [Sales], ALL('product list'[product name]) ) )
relative proportion
Overall relative proportion
DIVIDE( [Sales], CALCULATE( [Sales], ALLSELECTED('Product List') ) )
Relative proportion of categories
DIVIDE( [Sales], CALCULATE( [Sales], ALLSELECTED('Product List'[Product Name]) ) )
external filter
Level proportion (this level accounts for the parent level)
ISINSCOPE
Judgable level
It needs to be judged from the child level to the parent level, from bottom to top.
Operation logic can be customized
SWITCH( TRUE(), ISINSSCOPE('Product Table'[Product Name],[Relative Proportion of Category], ISINSSCOPE('Product Table'[Product Category],[Overall Relative Proportion], [overall relative proportion] )
Ranking calculation
RANKX
Iteration function, the first parameter is the table, which is the row context
The fifth parameter can control ascending and descending order, the default is descending order'
single dimension
absolute ranking
RANKX(ALL('Product List'),[Sales])
RANKX(ALL('Product List'[Product Name]),[Sales])
relative ranking
RANKX(ALLSELECTED('Product List'),[Sales])
RANKX(ALLSELECTED('Product List'[Product Name]),[Sales])
two dimensions
CROSSJOIN
Returns the table of cross products of the specified table
RANKX( CROSSJOIN( ALL('product list'[product name]), ALL('Customer table'[Customer city]) ), [Sales] )
Specify ranking
Top N names
IF nested ranking function implementation
Nested parameter values enable dynamic ranking
Nth place
#1 product
CALCULATE( MAX/VALUES('product list'[product name]), FILTER( ALL('Product table'), [Overall absolute ranking]=1 ) )
Nested parameter values enable dynamic ranking
TOPN and others
Non-TOPN products are aggregated into other items
Create new table
UNION( VALUES('product list'[product name]), {"other"} )
grouping problem
Calculated column static grouping
Create new column
IF function
customize
average value
Dynamic grouping of measures
Create a price grouping table
customize
average value
Revised total
Group application
frequency distribution
Auxiliary table
Sample measure
Static Pareto Analysis
Dynamic Pareto Analysis
Time related
Previous period/month-on-month
the day before
Date dimension table must be used
last month
last quarter
More flexible way of writing
month-on-month
Year-on-year
last year
last year
Month-on-year
year to date
last year year to date
rolling sum
Moving the total for a fixed time period
time intelligence function
DATESINPERIOD
Data correction
moving average
Historical accumulation
fiscal year
DAX
Create fiscal year and fiscal quarter date dimensions (calculated columns)
Weekly analysis
Same time last week
week to date
week-on-week
Make sure there are fields related to "week" in the date dimension table
Multiple date analysis
Create an inactive relationship
Activating relationships using functions
Previous issue on any date
Compare any time period
Create a comparison date table (copy the original date table)
Compare the date table with the original date table to establish an inactive relationship, compare the date to filter the original date
common problem
total revision
The total is equal to the sum of the details one dimension
two dimensions
Blank correction
Missing dimension - complete dimension
Calculation result value blank - 0 after measure value
Calculation result text is blank-&&""
Auxiliary table production
Excel import
Use "Enter Data"
DAX new table
Text custom sorting
Sort by column (corresponding to numeric columns)
Measurement folder management
Base
DAX shortcut keys
ctrl wheel zoom in and out
shift enter to wrap and indent
alt enter newline without indentation
ctrl [/] cancel left/right indentation
alt ↑/↓ move the current line up/down
ctrl i selects the current line
shift ctrl enter insert a line above
ctrl shift k delete line
//comment symbol