Join the discussion

Create Matrix passage visual

by on Latest post on by

1 Reply 82 Views

1 Reply

82 Views

Conditional Formatting basede on previous values t...

by on Latest post on by

5 Replies 790 Views

5 Replies

790 Views

Question regarding the matrix table

by on Latest post on by

2 Replies 84 Views

2 Replies

84 Views

Turn on and off Tooltip based on certain criteria

by on Latest post on by

1 Reply 132 Views

1 Reply

132 Views

Report Matrix how to show

by on Latest post on by

2 Replies 162 Views

2 Replies

162 Views

Conditional formatting not working in a matrix

by on Latest post on by

2 Replies 114 Views

2 Replies

114 Views

Calculate opening balance together with transactio...

by on Latest post on by

8 Replies 588 Views

8 Replies

588 Views

Multiple Rows in Matrix with Calculated Measure Pr...

by on Latest post on by

2 Replies 179 Views

2 Replies

179 Views

Matrix Subtotal - Subtotal

by on Latest post on by

1 Reply 132 Views

1 Reply

132 Views

Sum some rows in matrix

by on Latest post on by

3 Replies 228 Views

3 Replies

228 Views

Measure Subtotals in Matrix not working for both R...

by on Latest post on by

5 Replies 951 Views

5 Replies

951 Views

Custom Total in Matrix

by on Latest post on by

3 Replies 686 Views

3 Replies

686 Views

Helpful resources

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