All Questions
18 questions
0
votes
0
answers
29
views
SUM value is same in Power pivot
I want to calculate the sum of prescription projection value against each manufacturer. but the values are same for each manufacturer.
I have two fact table. (FactPrescriptionProjection,...
- 641
0
votes
1
answer
1k
views
Running total of a measure which use DATESINPERIOD and months from fact table
I am using a measure below to display the months from fact table as described here:
Billings12Months =
CALCULATE (
SUM ( 'Datatable'[Allowable] ),
DATESINPERIOD ( DimDate[Date], MIN ( ...
- 514
0
votes
1
answer
912
views
Calculate parent value on leaf level from a fact table with different granularity levels
I'm not sure if the data model is well suitable for what I want to compute, but I would like first to try if it's possible according to the dataset format provided.
The dataset provided by a data ...
- 424
1
vote
1
answer
526
views
New calculated table in DAX order by the count
I am using SSAS Tabluar models and I am trying to create a calculated table based on the count of each subcategory.
ColumnA ColumnB
SPN100 new
SPN100 old
SPN100 new
SPN200 new
...
- 527
0
votes
1
answer
77
views
DAX - Measure count active products
Tried a lot but didn't get any expected result.
I need a DAX measure which shows me the second result:
Based on my 2 tables, I need to know how many products is active if they appear in the second ...
- 161
0
votes
1
answer
163
views
Dax Measure - Value table compare value
I have a table FactSales
And tried but didn’t get ant satisfactory result.
Id like to calculate old results and compare to my actual one and see how many customers whose bought product B before (...
- 161
0
votes
0
answers
348
views
DAX - Inactive customers
I have a measure like below which returns me all active customers who in the last 90 days bought product category = 'A'
CustomersActive last 90 days:=
VAR Last90Days=
MAX (DimDate[Date) - 90
...
- 161
-1
votes
1
answer
789
views
Customers who bought and not bought some product in last 90 days
I need a dax measure which shows me which customers bought products B and C in last 90 days.
And another one which shows me those whose bought products B and C in last 90 days.
(based in my filter ...
- 161
0
votes
1
answer
248
views
DAX Measure if client has bought product A or B later
I need a DAX measure which shows me a flag (1 or 0) if a customer (DimCustomer) bought the product "A" someday (for the first time) and later (doesn't matter when) have bought or product "B" or "C".
...
- 161
1
vote
1
answer
458
views
Dynamic X-Axis Date Range Based on Disconnected Slicer
I have an issue that I need a hand with. I am using a disconnected slicer based off of this table
Time Frame :=
DATATABLE("ID", Integer, "Time Frame", string
, {
{1, "3 Month"}
, {2, "6 Month"}
, ...
- 1,781
1
vote
2
answers
82
views
Counting latest instance of multiple only based on filter context
I've got a large table of events that have occurred in an inventory of vehicles, which affect whether they are in service or out of service. I would like to create a measure that would be able to ...
- 13
1
vote
1
answer
117
views
Sum values from different columns with same parent in DAX
My case is a bit complicated so I'll try to explain it first but the pictures will be more helpful I think. Here is my table :
If there is an 'Id' "7409" in a 'Parent', I want the 'Amount' of this '...
- 378
0
votes
1
answer
2k
views
How to calculate the number of new customers every year in DAX
I have to calculate the number of new customers for every year.
Here is my table,
and here is the expected result.
The tricky part is that I don't have to only count the difference between two ...
- 378
0
votes
2
answers
261
views
How to make a dynamic measure based on the date chosen
Is it possible to create a calculated measure that calculates differently on the basis by the date chosen dynamically from the related time table "DimDate"?
So i want a static date "2017-01-01" that ...
- 326
2
votes
1
answer
4k
views
Why does my filter not work with calculated measures in Power BI, Power Pivot Excel?
I'm working with AdventureWorksDW2014. I created 2 measures, however they did not behave the way expected when i applied filter.
I have 2 tables FactInternetSales and DimCustomer. They are linked ...
- 21
1
vote
1
answer
262
views
DAX Time Intelligence custom previous periods
My cube has a fact table with a "Sales" column.
There is a related Date Table "SalesDate" (properly marked as a Date Table)
I created a measure for "average sales" called [AvgSales]
There is also a ...
- 11
1
vote
1
answer
226
views
PowerPivot publish to SSAS with Power Query Connection
I use Power Query to do ETL work then load data into PowerPivot model. Then later I imported PowerPivot to SSAS cube.
I successfully imported the model into SSAS cube. Silly question really but I ...
- 403
0
votes
2
answers
83
views
Consumer PowerPivot/Excel DataModel from another Excel file?
Short version: Is there any way/hack to use the embedded DataModel/PowerPivot cube of an Excel 2013/6 file from another Excel file?
Long version:
We have a large Excel Data Model with >400k rows and ...
- 17.4k