Questions tagged [dax]
The Data Analysis Expressions (DAX) language is a formula language that allows users to define custom calculated columns and measures in PowerPivot and Tabular SSAS models.
15
questions
0
votes
0
answers
101
views
Dynamic RANKX DAX Measure to Select Top % Value and filter by it
I have customer, location, and sale tables of data which when related in Power BI give similar sample data like the example below. For simplicity, I have just included the primary keys for customer ...
- 13
0
votes
1
answer
2k
views
DAX Calculate the sum of values for a year with start date and end date
I can't manage in DAX, to calculate for a year, the sum of the values which are in this year, I would like the proportion of each of the values in a year according to its starting date and its ending ...
1
vote
2
answers
4k
views
How to reference column of DAX variable?
I have a DAX variable that contains a table. How can I reference a particular column in that variable?
For example, in the below command, the EVALUATE returns an error. But it works if I replace ...
- 11
1
vote
0
answers
111
views
Dax Formula for Calendar
I have been trying to make a new table and want to use the date of the existing data. Can anyone help me understanding what is wrong with this formula?
dDate = CALENDAR(DATE(YEAR(MIN(Ftransactions[...
0
votes
0
answers
34
views
Help with the complex DAX measure
I am struggling with a DAX measure. Here is the fact and 2 dimension tables I have:
factAction(dimAccountID, dimActionID, Date, ActionQty)
dimAction(dimActionID, ActionCode, ActionDescription)
...
- 1
0
votes
1
answer
151
views
Group by in DAX like in SQL
How can I convert this SQL statement to DAX?
SQL query and tables:
select SUM(Kiekis )
from Info
left outer join Prekes on Info.PrekeID = Prekes.PrekeID
left outer join PrekiuGrupes on Prekes....
2
votes
2
answers
157
views
Counting rows in a table based on subtable result
Sample data:
--------------------------------------------------
| Customer | Value |
--------------------------------------------------
| A | 5 ...
- 21
2
votes
0
answers
2k
views
Getting MAX of AVERAGE measure (Power BI/DAX)
I am stumped. I am calculating an average of products sold per location. Then, I am using AVERAGEX to calculate that average for each sales associate.
But how do I find the MAX of that average and ...
- 33
0
votes
1
answer
887
views
Link DAX OpenQuery Output to SQL Server Temp Table
I want to record measures from a Tabular model, as KPIs, and store the values in a table in SQL Server.
I have created a linked server from my SQL Server instance to my SSAS instance.
I have written ...
- 382
0
votes
1
answer
343
views
Multi condition DAX row filter
I am trying to convert the following SQL row level security function into a DAX filter within a Tabular model
CREATE FUNCTION [Security].[fn_securitypredicate](@BrandID AS INT, @ChannelId AS INT)
...
- 326
1
vote
0
answers
95
views
Making a KPI table in SQL or with dax?
I am going to make a KPI table, however I've yet to decided where to make it. In essence its going to show weekly numbers derived from our customer database.
*Weeknumber
*New users (users with ...
- 55
1
vote
0
answers
155
views
SSAS 2014, Relation OLAP - Poor performance, high resource usage, what did I do wrong?
Let me start with the background, I was working on a project that needed a back end that was scalable and fast. Having worked quite a bit with SSAS, I thought I'd try SSAS's in memory solution, ...
- 121
1
vote
1
answer
813
views
MDX measure to DAX conversion
I needed a little help on working with MDX and DAX. Recently I have just started working with these two terms and am having a little trouble figuring out the differences and possible examples of how ...
- 111
1
vote
1
answer
152
views
Filtering by many-to-many table
I'm having a hard time to understand how to filter out result of multidimensional expression.
This is my database schema.
And this is my data.
Manufacturer
╔════╦═══════════════════╗
║ Id ║ ...
7
votes
2
answers
2k
views
Calculated Measure to get only most current from one dimension on snapshot fact but keep other filters
I'm working on a tabular cube in SSAS 2012 SP1 CU4. I have 3 dimensions (Requisition, Requisition Status, Date) and 1 fact (Requisition Counts). My fact table is at the grain of requisitionKEY, ...
- 824