Join the discussion

Filter with DAX

by on Latest post on by

1 Reply 140 Views

1 Reply

140 Views

DAX Function to show same figure in the grand tota...

by on Latest post on by

3 Replies 121 Views

3 Replies

121 Views

How to obtain a return series?

by on Latest post on by

1 Reply 66 Views

1 Reply

66 Views

Rankx is not working count

by on Latest post on by

3 Replies 175 Views

3 Replies

175 Views

Filter count

by on Latest post on by

7 Replies 164 Views

7 Replies

164 Views

creating target and difference account owner wise ...

by on Latest post on by

2 Replies 153 Views

2 Replies

153 Views

DAX to caculate % of total brand

by on Latest post on by

2 Replies 100 Views

2 Replies

100 Views

MDS Override Dax Query

by on

0 Replies 177 Views

0 Replies

177 Views

getting a '1' or '0' based upon a date column and ...

by on Latest post on by

3 Replies 142 Views

3 Replies

142 Views

Distinct Count for items listed planned but date c...

by on Latest post on by

5 Replies 222 Views

5 Replies

222 Views

Is there a way to count the amount of date overlap...

by on Latest post on by

16 Replies 1650 Views

16 Replies

1650 Views

Waiting for sharepoint

by on Latest post on by

1 Reply 243 Views

1 Reply

243 Views

Growth rate visual

by on

0 Replies 121 Views

0 Replies

121 Views

DAX Measure to calculate which number appointment ...

by on Latest post on by

3 Replies 176 Views

3 Replies

176 Views

Take the latest value in a subcategory and roll it...

by on Latest post on by

2 Replies 184 Views

2 Replies

184 Views

Matrix calculated measure not correct at lower lev...

by on Latest post on by

7 Replies 296 Views

7 Replies

296 Views

DAX SWITCH TRUE - help needed

by on Latest post on by

6 Replies 322 Views

6 Replies

322 Views

Calculate if ReceivedTime Is In Working Hours

by on Latest post on by

3 Replies 271 Views

3 Replies

271 Views

DAX formula for new columns with groups

by on Latest post on by

6 Replies 378 Views

6 Replies

378 Views

Show Row Based on a Start Date and End Date

by on Latest post on by

1 Reply 192 Views

1 Reply

192 Views

SAMEPERIODLASTYEAR function begins at wrong period

by on Latest post on by

1 Reply 120 Views

1 Reply

120 Views

Count values generated by measure across dates tab...

by on Latest post on by

3 Replies 255 Views

3 Replies

255 Views

Add current value to previous row value (with cond...

by on Latest post on by

2 Replies 378 Views

2 Replies

378 Views

Helpful resources

DAX 921
Need Help 456
DAX Calculation 186
Measures 118
Filter 92
help 81
measure 77
CALCULATE 66
Dax Help 61
Power BI 54
Need Help DAX 54
Date 43
DAX Query 43
Help Requested 42
Need Help DAX measure 41
COUNT 41
DAX filter formula 37
Help me please 37
RANKX 35
Help required 33
Tips and Tricks 31
Time Intelligence 30
POWER BI Dax rules 30
Calculated columns 29
Table 28
DAX Commands and Tips 28
sum 27
SUMMARIZE 26
DAX Commands 24
Help with DAX 24
average 24
Help me 23
dax measure 22
if statement 21
Show and Tell 21
Slicer 20
dates 19
Filtering 19
TopN 19
if 18
Help with DAX Measure 17
Filters 17
Conditional Formatting 16
Date and Time 16
DATEDIFF 16
Formula 16
Matrix Visual 15
running total 15
Distinct 14
PowerBI Desktop 14
LOOKUPVALUE 14
help needed 14
DAX. CALCULATE 13
Power Query 13
Get Help 13
dax functions 13
percentage 13
distinctcount 13
all 12
calculated column 12
DAX function 12
ranking 12
DATEADD 12
Calculatetable 12
Desktop 12
ALLEXCEPT 12
help in dax Function 11
ALLSELECTED 11
RLS 11
Power BI Dax 11
powerbi 11
YTD 11
Max 11
matrix 11
hierarchy 10
sumx 10
DAX For Filter 10
Filter context 10
Month 10
Switch() 10
values 10
Measure Column Total 10
divide 10
Related Tables 9
Date measures to filter data. 9
averagex 9
Dax commands help 9
COUNTROWS 9
time functions 9
Compare 9
Distinct Counts 9
if condition 9
SELECTEDVALUE 9
rank 9
VAR 9
@NeedHelp 8
datesbetween 8
switch 8
USERELATIONSHIP 8
Year 8
MAXX 8
tables 8
Difference 8
Cumulative Sum 8
Dynamic Date Period 8
columns 7
variables 7
crossjoin 7
DAX Time Intelligence 7
DAX Filtering 7
average of a measure 7
Power Pivot 7
groupby 7
value 7
measure based on slicer 7
DAX Measures 7
DAX Direct Query 7
time 7
column calculation 7
needhelp 7
blank 6
Cumulative Totals 6
Top N 6
SUMIF 6
Data Modeling 6
cumulative 6
Aggregation 6
total 6
TOTALYTD 6
index 6
currency conversion 6
column 6
join 6
Urgent Help 6
CountIfs 6
slicers 6
Table Visual 6
min 6
General 6
All() 6
AND 5
Visual 5
DAX RANKX 5
card 5
Totals 5
Group By 5
QTD 5
pareto 5
calculated table 5
Matrix Visualisation 5
rolling 12 5
percentages 5
Virtual Table 5
Tutorial Requests 5
CONTAINS 5
SQL 5
change 5
today 5
DAX BUG 5
subtract filtered value 5
context 5
Urgent Help with DAX 5
conditional 4
COUNTX 4
optimize 4
EARLIER 4
cumulative value 4
Average Grand Total 4
SQL to DAX 4
Switch Metric 4
subtotals 4
Many to Many Relatioinship 4
calculation groups 4
crossfilter 4
rows 4
Variable calculation 4
Need Help - Goals 4
MAX date 4
minx 4
dynamic table 4
@Please Help 4
Help appreciated 4
Direct Query 4
CONCATENATEX 4
KPI 4
Calculations 4
Text 4
tabular 4
Formatting 4
POWER BI DATA VİEW 4
sumifs 4
rolling 4
SSAS 4
column selection 4
Summary 4
isfiltered 4
Measures to filter out 4
grouping 4
lookup 4
chart 4
Dax studio 4
MTD 4
PowerBI Community 4
LASTNONBLANK 4
variable 4
Tip & Tricks 4
DAX ALL PowerBI Excel 4
Need Info 4
group 4
Sumx() 4
datesinperiod 4
VLOOKUP 4
SUM of Units 3
Performance Issues 3
relatedtable 3
Circular dependency 3
Power BI Desktop 3
calculated rows 3
Search 3
dax mode count 3
Field Value 3
context filter 3
Weekday 3
Visual Filtering 3
PBI Desktop 3
metrics 3
Slicer Visualizations 3
Waterfall Chart 3
Merge 3
DAX SWITCH 3
rolling dates 3
Dax Join 3
hasonevalue 3
weighted averages 3
Pareto Chart and table by Period help 3
what if parameters 3
running balance 3
INACTIVE RELATIONSHIP 3
keepfilters 3
Standard Deviation 3
Filter Multiple Column 3
range of text 3
Interesting Links 3
calendar 3
tutorials 3
Calc column assistance 3
Need help (Using direct query) 3
Format 3
CUMULATIVE COUNT 3
date slicer 3
condition 3
IF ELSE 3
Visualization 3
averages 3
Loop 3
multiple rows 3
Data Protection 3
bar chart 3
Line chart 3
selected values 3
REMOVEFILTERS 3
Unique Value 3
related 3
Performance 3
date calculation 3
Last date 3
Report 3
Dynamic 3
Slicer based on calculated Measure 3
SAME PERIOD LAST YEAR 3
function 3
Optimizing DAX 3
Tips 3
color 3
forecast 3
ID 3
date interval 3
dax formula 3
Conversion 3
dax tip 3
DAX Data Table 3
Date Table 3
Year over Year 3
bar charts 3
Filter based on context 3
SUMMARIZECOLUMNS 3
Cumulative Totals by category 3
query 2
date format 2
column total 2
benchmark 2
previous year 2
Total wrong in matrix 2
Categories 2
SVG 2
30 2
sort formula 2
@Dax Measure Error 2
Need Help re Measure Formatting 2
Groups 2
combine 2
Variances 2
holidays 2
subtotal 2
PowerBI Help 2
cumulative sum by category 2
Advanced filtering 2
NOT 2
Excel 2
SLA 2
dynamic filter 2
Power 2
timeline 2
Regression 2
Median 2
Managing Roles 2
Data Modelling 2
General Question 2
grand total row incorrect 2
Forecasting 2
Age 2
previous 2
Retention 2
drill 2
@Dax 2
New Challenge 2
mdx 2
exclude 2
concatenate 2
relations 2
custom formula 2
unpivot 2
Last 2
DAX Language 2
Calculatetable filter 2
DAX Syntax 2
Visualisations 2
Count rows (date) by month 2
beginner 2
Composite Model 2
Custom Filter 2
Calander 2
Row 2
Security roles 2
selection 2
while 2
negative 2
firstdate 2
aggregate 2
relationships 2
i 2
New Help 2
Azure Analysis services tabular model 2
Max date from select dates in Dataset 2
Last Year 2
weighted distinct count 2
count distinct with condition 2
Total Sum 2
Week time intelligence 2
DAX Hierarchy 2
SUM based on existing context created by a measure 2
drillthrough 2
Ignore Slicers 2
row context 2
distribution 2
e 2
complex 2
searching from 2 tables 2
budget 2
Need Hepl 2
cummulative 2
available 2
multiple column 2
union 2
update 2
M Query 2
cumulative percentage 2
OR function 2
grouped 2
dates table 2
SUM of MAX 2
Workday 2
conditional column 2
SSAS Tabular 2
General Comment 2
Reporting 2
yoy 2
percentile 2
unique 2
DAX for max utilisation 2
% 2
sumtotal 2
Search table columns for similair data 2
Direct Query mode 2
sorting 2
date hierarchy 2
custom column 2
Dashboard 2
Query Editor 2
employee 2
In 2
grand total 2
tricks and tips 2
Rolling Months 2
multiple tables 2
sales 2
COUNTIF 2
day 2
partial 2
How To 2
Multiplying by Sum 2
Summerizecolumn 2
New Table creation 2
Dynamic data selection based on date 2
WEEKNUM 2
Rankx with filter 2
Calculated Measures Only 2
DAX Max Date within date range 2
guidelines 2
Previous month 2
date range 2
line graph 2
M 2
FILTERS DAX KEEPFILTERS 2
help with date 2
Calculate function with multiple criteria 2
Iterator 2
Countdistinct 2
Row Level Security 2
previous week 2
Analysis Service 2
calculated tables 2
duration 2
Events in progress 2
addcolumn 2
variance 2
Userrelationship 2
Month on Month Rank Comparison 2
blanks 2
measures in calculated columns 2
CALENDAR() 2
Questions 1
snapshot 1
queries 1
parameter 1
Scheduled data refresh 1
Dynamics 365 1
Desktop version 1
sharepoint online 1
Sum on a dynamic date range 1
Company Average 1
LLY 1
one inn many 1
Summarize() 1
incorrect total 1
salary 1
XLOOKUP 1
Error due to relationship 1
Likert scale 1
Nominator 1
Decomposition Tree 1
DAX CALENDARAUTO() 1
Integer 1
available time 1
List sorting 1
overlaying graph 1
Combine Values 1
12 hour 1
Start and end period 1
cummulative dax 1
isinscope 1
Intersect 1
ADDCOLUMNS() 1
Last N Months Data 1
busqueda rangos 1
Meausre 1
Sample 1
Gantt chart 1
need 1
formating 1
Quarter 1
scatterplot 1
IFNA excel funation alternative 1
levels 1
Assigning Roles 1
Parameter formatting 1
Advanced Visualization 1
FIFO 1
BI Vs Tableau 1
not equal to 1
include 1
CD and CSD 1
ArcGIS Map 1
40 1
count of count 1
Denominator 1
expressions 1
stacked column chart 1
Hierarchy of Slicers 1
Top5 with Other column 1
deadline 1
tMonth 1
chart axis with no data 1
@ Matrix Visualisation Error In Calculation 1
Groupings 1
one slicer to filter another table 1
24 hour 1
visual filter 1
Minimum AVG 1
SCD2 1
Quarter Issue 1
@dax @help 1
rangos 1
first per day 1
Advanced 1
Google Analytics 1
finance 1
Embed Report 1
Streaming Datasets 1
numbers 1
Region 1
% complete 1
Analysis 1
Stock Valuation 1
churn 1
subgroups 1
suggestions on Data Analysis 1
ORDER 1
empty columns 1
testing 1
Replace Values Based on Another Column 1
&& 1
Dimension 1
Work days 1
50 1
tooltip 1
ee 1
To Show Ratio 1:2 1
conditional columns 1
resets if 0 1
Row Number in DAX 1
90 1
work load 1
customer concentration 1
conditonal formatting 1
rowlevelsecurity 1
@stock_managment 1
relationship 1
change format 1
filter by date hierarchy 1
@get help 1
DATEADD Visit Windows 1
slicer calculation 1
Average from Matrix 1
Conteo 1
maxium 1
dax calculations 1
Model 1
Pricing 1
BUG 1
Active Directory 1
Memory 1
Format Date 1
FX 1
Margin 1
graphs 1
.DAX 1
Capital Gain 1
change variables 1
pre 1
profit and loss 1
"aggregations" 1
Access Control 1
result 1
expand 1
"Calculation Group" 1
ALLSELECT SURVIVAL RATE 1
HR 1
Day of Week 1
semi-additive 1
Data Type 1
Year to date 1
Group By For Two Columns in Dax 1
Window Function 1
NewBusiness 1
volume concentration 1
Delimiters 1
perce 1
@inventory @DAX 1
change time format 1
revenue 1
exponent 1
ratio calculations dax 1
weeks 1
help measure 1
unico 1
Pareto Chart 1
categorization 1
Salesforce 1
Please help 1
date slicers 1
default 1
refresh data 1
Icons 1
power bi visuals 1
Hierarchy slicer 1
Exchange 1
segmentation 1
Share Valuation 1
" cumulatives" 1
dashboard dax help 1
maximum 1
credit 1
simple 1
add value from prior row measure 1
new measure of % by group 1
custom sorting 1
Help to update datasource 1
If Then 1
Turnover 1
Type 1
Average Sales 1
First Value 1
LostBusiness 1
concentration curve 1
Every 1
Variation 1
times 1
country 1
actuals 1
static value 1
@Greg_Deckler @Mich_J @amitchandak 1
repurchase 1
Transliteration 1
by count 1
recruiting 1
survey 1
Education 1
analysis services 1
Data Source 1
Scorecard 1
Urgent 1
CSV 1
Calendars 1
Cumulative sum partition 1
Stock In Hand 1
Transaction 1
numbertostring 1
Nonlinear Regression 1
Production 1
debit 1
F 1
Please save me 1
Test as a Role 1
Technical question 1
have 1
cumulative sum by multiple criteria 1
dyanmic 1
opening balance 1
ReturningBusiness 1
customer percentage vs sales percentage 1
Dynamic Ranking 1
ISNUMBER 1
WTD 1
display 1
filtrar 1
capacity 1
isnonblank 1
hour 1
transform 1
by group 1
Duplicates 1
data 1
themes 1
to 1
ALLCROSSFILTERED 1
Mean Time Between Failure 1
line chart visual 1
active customers 1
financial report 1
dataype 1
in chosen periods 1
title 1
I'm losing my mind 1
previousmonth 1
EARLIEST 1
Market Share 1
Analysis Server 1
Find multiple values 1
utilization 1
Past & Current Month Latest data 1
Operator 1
su 1
daily difference 1
category 1
multiple join 1
fiscal 1
Dynamic Index 1
a da 1
Average x month-13 1
Rolling inventory in each month associated with SKU 1
@countifs functionality @Need Helop 1
Maxdate 1
relative date slicer 1
filtro de tiempo 1
completed 1
DAX table filter 1
new user 1
Rowtotal 1
QTR 1
Comparing columns 1
Duplicate data 1
evaluation 1
Scheduling 1
gauges 1
counts 1
range 1
two tables 1
Match 1
date ranges 1
timeline report 1
multiple date tables 1
MoM 1
Null 1
Help with DATESYTD DAX 1
transitive closure 1
Dynamics CRM 1
Custom calendar 1
Multiplication and wrong total in table 1
filter direction 1
Line and stacked column chart 1
Lowest Market Share 1
Productivity 1
pivot table 1
able 1
Day on Day 1
Realtotals 1
new calculated table 1
consolidation 1
Report view 1
conditional format 1
verting H 1
many to many 1
org chart 1
firstnonblank 1
Inventory 1
quota 1
Alias on summ 1
dax calculated 1
VAT 1
comapring 1
community 1
R 1
Subscription 1
Maximum number of values 1
transpose 1
Power KPI Matrix 1
metric 1
Power BI Help 1
loop up values from 2 tables 1
tutorial request 1
last date time refresh 1
spend 1
Power BI report builder 1
Tableau 1
Lookupvalues 1
selected value 1
Running Totals 1
yield 1
Ordered Vs Delivered 1
usage metrics report 1
facts filtering dimensions 1
Rebasing 1
Row Average 1
Column Chart 1
remote computers 1
commands 1
Week 1
Previous Month Last Year Card 1
compound 1
new calculated column 1
YoY Line Charts 1
font colour 1
scalar 1
with filters 1
filter context intersection 1
Table cell background color 1
"beginner asks Help" 1
Customer Revenue Comparison 1
Overlapping tables 1
math 1
Mongodb 1
For Loop 1
headcount when have FT and PT in department 1
Dynamic slicer flag column 1
correlation 1
live dashboards 1
Map 1
key 1
timeline slicer 1
text filter 1
python 1
conditions 1
Expertise help 1
funnel plots 1
Object level security 1
M language 1
DATESYTD Help needed 1
ONE TABLE MODEL 1
Bundle 1
DAX for deals added and slipped 1
calculate Percentile 1
Atingir Meta e Solver 1
reference text 1
Total not matching 1
Top5 and Bottom 5 1
@Ranks with Trend 1
color palette 1
returns 1
hex 1
if and else 1
date filter 1
EarlierFunction 1
Concatenate columns in a measure 1
background color 1
New quick measure 1
14 day 1
Overlap 1
newbie 1
predictive models 1
running a Query with two tables to show each row 1
Split column 1
DAX tips 1
Custom Visual 1
s 1
Embed 1
Dynamic Column 1
Roles 1
weekly-averages 1
Like for like pricing analysis 1
Floriankx 1
Visualizations 1
TOTALYTD through Today 1
changing classifications 1
product function 1
Currency 1
sql_to_dax 1
one row 1
total zero 1
Replace Text Based on Another Column 1
select all 1
veryon 1
aaa 1
Substract with a measure 1
return 1
scenario 1
show statusRDP 1
Moving average for measures 1
mailto 1
PRICE_NAME SUM(CALLS_SUM) AD 12 1
replace 1
DAX formulas for total quantity matching 1
Monthly percentages 1
countblank 1
Bin 1
Quarter over Quarter 1
Conditional Formation Icons 1
sum vs target 1
working days 1
Case statement 1
NBA 1
Runnig Total 1
dynamic field 1
DATESMTD() 1
Design 1
Azure 1
Live Connection 1
scheduled 1
running-totals 1
many to many relationship issue 1
kcantor 1
pie chart tree 1
Unhandled 1
SPC DAX XMR chart Control limits 1
correct visuals 1
mailchimp 1
Cound IDs 1
like to get 1
fortnight 1
COVID-19 1
Text Measure 1
fiscal period 1
file name 1
DAX Performace 1
BusinessCentral COA Totalling 1
remote desktop connection 1
Performance issues with AverageX 1
have a 1
subject line 1
741 ADM 14 1
annual 1
COUNTA 1
hI i 1
Path 1
running 1
optimised 1
Non Calendar FY and FQ 1
Previous Week comparison 1
multiple filters 1
Subtract 1
cardinality 1
Basket 1
record 1
Data model 1
error 1
What If 1
Visuals 1
node 1
Nee dhelp 1
iamprajot 1
where 1
automatic 1
Grouped field 1
by 1
Roleplaying 1
bad data 1
DAX com 1
Group total 1
TopN by Store 1
Rolling 12 Months 1
CODE 1
column percent 1
context transition 1
dynamic percentage calculation 1
Alternatives for AverageX 1
kpis 1
507 AE 990 AEDU 201 AEM 4 1
conditional replace 1
Parent 1
HASONEFILTER 1
SEQUENCE 1
Unique Measure. 1
sort 1
BINS 1
Help to Create Dax: applying filter for both Data Type(Text and Date) 1
TOTALMTD 1
DAV 1
related table 1
TopN Customer 1
data refresh 1
Fiscal Year 1
wildcard 1
imported 1
ovetteabejuela 1
Forex 1
New customers 1
Icon Formatting 1
Counter 1
comparison 1
count 0 and 1 1
status change 1
delete rows 1
Need to mark holidays in calendar 1
fill empy cell 1
Circle diagram 1
Line & Stacked Column 1
Comcatenation 1
Filter two tables 1
ab 1
sclicer 1
Dinamic rows 1
Approximate Lookup Dates 1
totals calculation not correct in matrix 1
outbound delivery 1
395 AEMD 2 1
Weekly YOY 1
Combination Table 1
Child 1
POPL 1
DAX formula for tracking daily death cases 1
Merge files 1
Moving average 1
Empty 1
List value account 1
Running Total Weekly 1
time-intelligence 1
Cumulative Total 1
STARTOFMONTH 1
Management 1
Security 1
Financial 1
Dynamic RLS 1
append 1
quetsion 1
pivot 1
WOW 1
v-qiuyu-msft 1
inner join 1
Measure Multiplication 1
side by side 1
evaluate total for a period for a specific column 1
stage change 1
Match calculated ranking column 1
INCORRECT CALENDAR 1
Tutorial 1
10 1
coalesce 1
Selections 1
resource utilzation 1
growth rate 1
basket analysis 1
RankX excluding Some Values 1
not display data 1
297 AF 36 AFME 2 AFMO 13 AFMW 9 AG 5 AGM 33 AGMD 23 AIMD 3 AIMF 2 AK 35 AL 82 ALMA 218 ALME 56 ALMV 854 AM 10 AMGG 1 AMGU 2 1
null value fields 1
weighted 1
Flag 1
Error of Expression Refers to multiple columns. Multiple columns cannot be converted to scalar value 1
Margin Percentage 1
Add "IF" before calculate 1
simulation 1
Parameter Data Type 1
month-to-date 1
Trend Line 1
NoData 1
calculation 1
Issue 1
Query String 1
tooltips 1
stacked bar 1
Combo Chart Report Server 1
normalize 1
row_number 1
last quarter 1
ThreeYear Average 1
Absolute Value 1
opportunity stage 1
Cummulative Prev Change 1
Append measure to table 1
"average" 1
Dynamic Flag 1
20 1
I need t 1
consecutive loss 1
Backlog 1
heed help on dax functions 1
funnel 1
multiple dates 1
bell curve 1
LastDate 1
POP&L 1
Tag rows 1
time format 1
Current Year VS Last Year 1
Networkdays 1
true () 1
i need help 1
invoice 1
cohort 1
KEEP 1
Tip 1