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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
31 views

Limit Power BI slicer to two (2) options

I have a column called "teams" and I want to write a dax statement that will limit user to only two teams at a time. Please remember that Teams is going to be a slicer. Valid Selection = ...
Sam Johnson's user avatar
1 vote
1 answer
39 views

How do I write a Dax statement that returns the current counts whenever I filter for a TEam

Below is my sample table and I'd like to write a Dax statement that returns the current count whenever I filter for Team A or B. Ideally, the current count per team would be on a card in power BI. ...
Sam Johnson's user avatar
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 ...
Gabriel Valvin's user avatar
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 ...
explorer's user avatar
1 vote
0 answers
133 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[...
alphabounce_1228's user avatar
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) ...
Steve's user avatar
  • 21
0 votes
1 answer
213 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....
Kristina Kristina's user avatar
2 votes
2 answers
186 views

Counting rows in a table based on subtable result

Sample data: -------------------------------------------------- | Customer | Value | -------------------------------------------------- | A | 5 ...
user169728's user avatar
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 ...
Scott Mohler's user avatar
0 votes
1 answer
978 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 ...
DimUser's user avatar
  • 382
0 votes
1 answer
377 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) ...
Adrian S's user avatar
  • 326
1 vote
0 answers
100 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 ...
B.Doe12's user avatar
  • 55
1 vote
0 answers
166 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, ...
Randall's user avatar
  • 121
1 vote
1 answer
905 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 ...
user282190's user avatar
1 vote
1 answer
167 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 ║ ...
OzrenTkalcecKrznaric's user avatar
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, ...
mmarie's user avatar
  • 834