DAX Commands and Tips

Join the discussion

Top N reason for the month

by on Latest post by

4 Replies 138 Views

4 Replies

138 Views

TopN from a Summarize Table keeping the filters -...

by on Latest post on by

5 Replies 162 Views

5 Replies

162 Views

Top 5 in Rows and Columns

by on Latest post on by

4 Replies 98 Views

4 Replies

98 Views

RANKX to do a TOPN - Lot of Data and Rows - Errors

by on Latest post on by

8 Replies 185 Views

8 Replies

185 Views

Max Value of the Sum of other Column

by on Latest post on by

2 Replies 95 Views

2 Replies

95 Views

How to show the bottom N in visual card

by on Latest post on by

1 Reply 58 Views

1 Reply

58 Views

Ranking with Dates and Genre

by on Latest post on by

4 Replies 135 Views

4 Replies

135 Views

Top N by each category

by on

0 Replies 49 Views

0 Replies

49 Views

TopN with Multiple Dimensions

by on Latest post on by

3 Replies 154 Views

3 Replies

154 Views

Retrieve Top N list on a global period to display ...

by on Latest post on by

3 Replies 202 Views

3 Replies

202 Views

TOP N With Multiple Condition

by on Latest post on by

2 Replies 183 Views

2 Replies

183 Views

Get the first [or only] value of a column of a giv...

by on Latest post on by

1 Reply 126 Views

1 Reply

126 Views

Trouble with TOPN not working

by on Latest post on by

2 Replies 218 Views

2 Replies

218 Views

Dynamic TOPN problem default value

by on Latest post on by

1 Reply 121 Views

1 Reply

121 Views

TopN Customers by Revenue filtered by Region, Coun...

by on Latest post on by

1 Reply 1832 Views

1 Reply

1832 Views

Helpful resources

DAX 529
Need Help 270
DAX Calculation 111
Measures 73
Filter 58
help 54
measure 47
Dax Help 46
DAX Query 41
CALCULATE 37
DAX filter formula 35
Power BI 29
COUNT 26
Help me please 24
Help required 22
Help Requested 22
Date 20
sum 18
dax measure 17
POWER BI Dax rules 17
RANKX 16
Help me 15
Table 15
Filtering 15
Tips and Tricks 15
TopN 15
SUMMARIZE 15
if statement 14
dates 14
Time Intelligence 14
if 13
average 13
Calculated columns 13
PowerBI Desktop 12
running total 12
all 12
help needed 11
Show and Tell 11
dax functions 11
help in dax Function 11
Formula 10
Filters 10
Matrix Visual 10
Slicer 10
DAX. CALCULATE 10
DAX function 9
Help with DAX 9
Distinct 9
percentage 9
values 9
Power Query 9
RLS 8
Date and Time 8
YTD 8
Calculatetable 8
distinctcount 8
Conditional Formatting 8
Help with DAX Measure 8
DATEADD 7
LOOKUPVALUE 7
DATEDIFF 7
Desktop 7
powerbi 7
matrix 7
time functions 6
General 6
Urgent Help 6
ranking 6
hierarchy 6
Cumulative Sum 6
Measure Column Total 6
Filter context 6
Top N 6
ALLEXCEPT 6
averagex 6
Dynamic Date Period 6
sumx 6
Max 6
rank 6
Related Tables 6
calculated column 6
DAX Direct Query 6
Power Pivot 5
Cumulative Totals 5
Compare 5
Power BI Dax 5
value 5
CountIfs 5
SELECTEDVALUE 5
Dax commands help 5
Data Modeling 5
measure based on slicer 5
Difference 5
groupby 5
columns 5
if condition 5
Urgent Help with DAX 5
Date measures to filter data. 5
crossjoin 5
index 5
calculated table 5
rolling 12 5
DAX RANKX 5
optimize 4
Get Help 4
VAR 4
USERELATIONSHIP 4
Distinct Counts 4
Year 4
Sumx() 4
average of a measure 4
group 4
join 4
Direct Query 4
Table Visual 4
Need Info 4
total 4
isfiltered 4
Tutorial Requests 4
cumulative 4
Virtual Table 4
tabular 4
Need Help - Goals 4
Switch() 4
DAX BUG 4
Dax Join 3
multiple rows 3
MAXX 3
VLOOKUP 3
QTD 3
@needhelp 3
Totals 3
card 3
rows 3
SSAS 3
TOTALYTD 3
date interval 3
Power BI Desktop 3
currency conversion 3
COUNTX 3
tables 3
Month 3
selected values 3
subtotals 3
Aggregation 3
averages 3
EARLIER 3
variables 3
weighted averages 3
lookup 3
Dynamic 3
Year over Year 3
divide 3
SUM of Units 3
calculated rows 3
dynamic table 3
chart 3
DAX Time Intelligence 3
dax mode count 3
Average Grand Total 3
Merge 3
SAME PERIOD LAST YEAR 3
DAX For Filter 3
tutorials 3
Waterfall Chart 3
COUNTROWS 3
KPI 2
duration 2
Slicer Visualizations 2
beginner 2
Composite Model 2
Calculations 2
Need Hepl 2
CUMULATIVE COUNT 2
drillthrough 2
SQL 2
what if parameters 2
Loop 2
M 2
Forecasting 2
percentile 2
Last Year 2
DAX for max utilisation 2
% 2
sumtotal 2
SVG 2
rolling dates 2
New Challenge 2
Max date from select dates in Dataset 2
condition 2
PowerBI Community 2
grand total 2
column calculation 2
grouping 2
SSAS Tabular 2
Reporting 2
pareto 2
forecast 2
searching from 2 tables 2
cumulative percentage 2
In 2
date range 2
drill 2
DAX SWITCH 2
CONTAINS 2
calendar 2
CONCATENATEX 2
color 2
e 2
complex 2
addcolumn 2
All() 2
sumifs 2
i 2
unique 2
relatedtable 2
context filter 2
keepfilters 2
percentages 2
LASTNONBLANK 2
Text 2
date slicer 2
Analysis Service 2
dynamic filter 2
MTD 2
Events in progress 2
previous year 2
AND 2
Total wrong in matrix 2
Categories 2
cumulative value 2
Dax studio 2
bar chart 2
employee 2
Variances 2
Total Sum 2
cummulative 2
Format 2
time 2
timeline 2
context 2
switch 2
slicers 2
Formatting 2
min 2
Conversion 2
Data Modelling 2
relations 2
distribution 2
Count rows (date) by month 2
conditional 2
Performance Issues 2
concatenate 2
grouped 2
dates table 2
Cumulative Totals by category 2
Circular dependency 2
benchmark 2
aggregate 2
sorting 2
SUMMARIZECOLUMNS 2
Weekday 2
guidelines 2
Performance 2
Median 2
SUMIF 2
firstdate 2
Matrix Visualisation 2
Need help (Using direct query) 2
IF ELSE 2
multiple tables 2
FILTERS DAX KEEPFILTERS 2
cumulative sum by category 2
Row Level Security 2
Variable calculation 2
Line chart 2
Switch Metric 2
count distinct with condition 2
Direct Query mode 2
Filter based on context 2
datesbetween 2
Filter Multiple Column 2
query 2
calculated tables 2
SQL to DAX 2
dax tip 2
bar charts 2
Data model 1
key 1
numbers 1
gauges 1
Hierarchy slicer 1
Exchange 1
minx 1
column selection 1
budget 1
Summary 1
OR function 1
bad data 1
fill empy cell 1
INCORRECT CALENDAR 1
XLOOKUP 1
PowerBI Help 1
40 1
tooltip 1
"Calculation Group" 1
have 1
cumulative sum by multiple criteria 1
Past & Current Month Latest data 1
Top5 and Bottom 5 1
have a 1
How To 1
finance 1
Duplicate data 1
PBI Desktop 1
Quarter 1
power bi visuals 1
while 1
negative 1
tutorial request 1
product function 1
Currency 1
sql_to_dax 1
one row 1
total zero 1
mailchimp 1
Cound IDs 1
Rolling Months 1
Need to mark holidays in calendar 1
variance 1
subtotal 1
Work days 1
50 1
expand 1
Help to update datasource 1
Find multiple values 1
utilization 1
Productivity 1
remote computers 1
Moving average for measures 1
Rankx with filter 1
Pricing 1
Subscription 1
date format 1
Region 1
CSV 1
Calc column assistance 1
ALLCROSSFILTERED 1
two tables 1
changing classifications 1
SPC DAX XMR chart Control limits 1
correct visuals 1
Roleplaying 1
tricks and tips 1
New Table creation 1
Match calculated ranking column 1
Dynamic Flag 1
holidays 1
result 1
custom sorting 1
Technical question 1
Week time intelligence 1
Lowest Market Share 1
available 1
Performance issues with AverageX 1
RankX excluding Some Values 1
update 1
Questions 1
Gantt chart 1
Visualisations 1
Visuals 1
metrics 1
selection 1
Power BI Help 1
loop up values from 2 tables 1
Expertise help 1
Slicer based on calculated Measure 1
by 1
variable 1
Append measure to table 1
"average" 1
salary 1
Dimension 1
new measure of % by group 1
custom formula 1
unpivot 1
Standard Deviation 1
Row Average 1
Column Chart 1
show statusRDP 1
Alternatives for AverageX 1
Month on Month Rank Comparison 1
Education 1
Query String 1
Streaming Datasets 1
Icons 1
POWER BI DATA VİEW 1
metric 1
conditions 1
comparison 1
count 0 and 1 1
ID 1
status change 1
delete rows 1
Summerizecolumn 1
incorrect total 1
CD and CSD 1
Test as a Role 1
Analysis Server 1
Measures to filter out 1
scenario 1
remote desktop connection 1
totals calculation not correct in matrix 1
Integer 1
Google Analytics 1
data 1
Scheduled data refresh 1
New Help 1
Visualizations 1
TOTALYTD through Today 1
Unhandled 1
Counter 1
side by side 1
evaluate total for a period for a specific column 1
stage change 1
include 1
Search 1
&& 1
add value from prior row measure 1
previousmonth 1
EARLIEST 1
Market Share 1
Rebasing 1
Substract with a measure 1
return 1
BusinessCentral COA Totalling 1
dynamic percentage calculation 1
Calculate function with multiple criteria 1
grand total row incorrect 1
date slicers 1
stacked bar 1
Azure Analysis services tabular model 1
Like for like pricing analysis 1
Floriankx 1
pie chart tree 1
last quarter 1
ThreeYear Average 1
Absolute Value 1
opportunity stage 1
Cummulative Prev Change 1
Summarize() 1
Replace Values Based on Another Column 1
Many to Many Relatioinship 1
Please save me 1
Multiplication and wrong total in table 1
filter direction 1
reference text 1
Total not matching 1
DAX Performace 1
Dinamic rows 1
Approximate Lookup Dates 1
heed help on dax functions 1
calculation groups 1
survey 1
R 1
Scorecard 1
Visualization 1
column total 1
many to many relationship issue 1
kcantor 1
where 1
automatic 1
Grouped field 1
Icon Formatting 1
LLY 1
one inn many 1
not equal to 1
"aggregations" 1
simple 1
title 1
I'm losing my mind 1
Ignore Slicers 1
facts filtering dimensions 1
Unique Value 1
Optimizing DAX 1
column percent 1
growth rate 1
basket analysis 1
DAX CALENDARAUTO() 1
Last 1
Excel 1
correlation 1
live dashboards 1
parameter 1
Active Directory 1
change 1
iamprajot 1
New customers 1
Multiplying by Sum 1
FIFO 1
BI Vs Tableau 1
empty columns 1
profit and loss 1
hasonevalue 1
INACTIVE RELATIONSHIP 1
Custom calendar 1
calculate Percentile 1
Atingir Meta e Solver 1
file name 1
CODE 1
sclicer 1
subtract filtered value 1
consecutive loss 1
Backlog 1
DAX Commands 1
opening balance 1
Embed 1
Visual 1
weekly-averages 1
ovetteabejuela 1
Forex 1
inner join 1
Measure Multiplication 1
Previous month 1
Advanced Visualization 1
Stock Valuation 1
churn 1
subgroups 1
suggestions on Data Analysis 1
ORDER 1
credit 1
F 1
in chosen periods 1
Ordered Vs Delivered 1
usage metrics report 1
veryon 1
aaa 1
SUM of MAX 1
Tip & Tricks 1
ab 1
help with date 1
stacked column chart 1
General Question 1
su 1
Azure 1
Embed Report 1
Scheduling 1
refresh data 1
running-totals 1
v-qiuyu-msft 1
needhelp 1
Company Average 1
Capital Gain 1
previous 1
Retention 1
change variables 1
pre 1
debit 1
dataype 1
yield 1
Bundle 1
DAX for deals added and slipped 1
COVID-19 1
Text Measure 1
fiscal period 1
Filter two tables 1
resource utilzation 1
Userrelationship 1
ALLSELECTED 1
resets if 0 1
Year to date 1
able 1
Interesting Links 1
Query Editor 1
queries 1
Visual Filtering 1
Maximum number of values 1
timeline slicer 1
quetsion 1
imported 1
normalize 1
row_number 1
Analysis 1
.DAX 1
Share Valuation 1
" cumulatives" 1
dashboard dax help 1
exclude 1
maximum 1
Production 1
financial report 1
Help with DATESYTD DAX 1
transitive closure 1
TopN by Store 1
Rolling 12 Months 1
function 1
Selections 1
Nominator 1
conditional columns 1
Data Type 1
Average Sales 1
Previous Month Last Year Card 1
s 1
TopN Customer 1
mdx 1
M Query 1
to 1
Combo Chart Report Server 1
Sum on a dynamic date range 1
Assigning Roles 1
Age 1
MAX date 1
Stock In Hand 1
Transaction 1
numbertostring 1
Nonlinear Regression 1
Null 1
selected value 1
ONE TABLE MODEL 1
select all 1
fortnight 1
Dynamic data selection based on date 1
WEEKNUM 1
Comcatenation 1
Likert scale 1
Denominator 1
semi-additive 1
Type 1
dyanmic 1
DAX Commands and Tips 1
community 1
Report 1
BUG 1
default 1
counts 1
sharepoint online 1
combine 1
IFNA excel funation alternative 1
levels 1
Field Value 1
Managing Roles 1
% complete 1
Cumulative sum partition 1
active customers 1
MoM 1
DATESYTD Help needed 1
REMOVEFILTERS 1
like to get 1
Group total 1
10 1
I need t 1
Day of Week 1
Pareto Chart and table by Period help 1
Operator 1
relationships 1
previous week 1
evaluation 1
What If 1
Urgent 1
scatterplot 1
Margin 1
graphs 1
Mean Time Between Failure 1
date ranges 1
timeline report 1
Power BI report builder 1
weighted distinct count 1
multiple date tables 1
M language 1
Replace Text Based on Another Column 1
Circle diagram 1
Line & Stacked Column 1
20 1
count of count 1
To Show Ratio 1:2 1
HR 1
DAX Hierarchy 1
pivot table 1
General Comment 1
snapshot 1
analysis services 1
node 1
Regression 1
FX 1
running balance 1
Match 1
last date time refresh 1
spend 1
weekdays 1
Tableau 1
Lookupvalues 1
Object level security 1
Search table columns for similair data 1
DAX com 1
Error due to relationship 1
30 1
ee 1
ALLSELECT SURVIVAL RATE 1
Turnover 1
Custom Filter 1
commands 1
@Ranks with Trend 1