Stack Overflow
Stack Overflow

Questions tagged [measures]

58 questions
1
vote
1 answer

SSIS Calculation with different total

I'm trying to show the amount of days a company travel has taken. The sales employee doesn't enter the exact amount so it is calculated in SQL and in the data load to DWH it is added to the TravelID. If travelID exists 3 times due to 3 trip lines…
ben.w
  • 43
  • 9
1
vote
1 answer

blank measures in ssas cube even when data is in source table

I've been working on a cube that has data in the fact table that is browsable through the DSV but after being processed seems to have blank values for all the measures. The common suggestions include checking the that the CALCULATE command is still…
Rowan
  • 463
  • 3
  • 8
  • 20
1
vote
1 answer

How to hide unwanted measures

AP 4.4.3, APL 2.7.0 Hi, When defining a post-processed measure we end up with two measures available to us in Active Pivot Live. E.g. the definition below will give us the measures "Yield Curve.SUM" and "Yield Curve.TenorDetail". As we've got a…
obrienk
  • 481
  • 5
  • 10
1
vote
1 answer

New Measure not visible in Dashboard Designer - SharePoint 2010

I have created a cube in Sql Server Analysis Service. I have a table called Orders which has several columns in which Quantity, Price and Cost are important. I have already added these fields as Measure in the cube and I can see these Measures in…
Merin Nakarmi
  • 3,148
  • 3
  • 35
  • 42
0
votes
2 answers

DAX - Calculate between two dates - Not getting results

I want to calculate the SUM(AMOUNT) between the beginning of the previous month (01-05-2018) and the DATEADD([Date];-1;MONTH) (21-05-2018). For that I'm using this: CALCULATE ( SUM(AMOUNT); FILTER (dataset; MAX(dataset[Date]) <=…
Pedro Alves
  • 1,004
  • 1
  • 21
  • 47
0
votes
1 answer

Dynamic Text in Power BI - Measures to support the Text

I want to create a dynamic text (Visual - Enlighten Data Story) that will write the measures X, Y and Z (see pictures below). X is the Activity that had the most energy consumption on that city (one of those: Industry, Transports, Services, etc…
Patrícia Silva
  • 3
  • 1
  • 2
0
votes
1 answer

How to group measures to display on a Power Bi Clustered chart?

I have several measures computed and I am placing them on the Line and Clustered column chart to display them side by side. The challenge I am having right now is i can not group them for displaying on the Chart. Please see the attached…
mdevm
  • 97
  • 2
  • 14
0
votes
1 answer

“Decrease” the measure in OLAP Cube

I have an OLAP Cube in which there is a Parent-Child Account Dimension. My goal is to set a certain measure value on the GROSS-PROFIT Account , with a certain logic : GROSS PROFIT = REVENUES - COSTS GROSS PROFIT is the parent of REVENUES and…
Dan.G
  • 1
  • 2
0
votes
1 answer

Arcobjects: set measures based on the polyline length

I am currently linear referencing a set of roads. Using IMSegmatation2.SetMsAsDistance2 works fine for single-part polylines but for multi-part polylines I want to set the M values as the length along the polyline to the point, not the shortest…
John M
  • 53
  • 7
0
votes
1 answer

Power Pivot: sum column a if sum column b > 0

I am at my wit's end regarding the following table entries within a power pivot model and the targeted measure/result. We have the following data: Entity Invoice Lease 1 15 14 1 20 20 1 100 2 …
Gökhan Acar
  • 1
  • 1
0
votes
1 answer

SQL Server Analysis Services - How to filter just one measure by date and left another measure without filter?

Hy guys! I have the following scenario: One cube with one dimension and two measures (sum of values). My user want to try to get the following results: Choose one date column, that I'll call date1 from the dimension as a column title, choose both…
Angelo Braga
  • 1
  • 1
0
votes
1 answer

Understanding SonarQube C code coverage measures

I have a SonarQube 5.6 installation, using C/C++ plugin 3.12 to analyse our project. I have generated coverage results (gcov), but so far only for one of the application C files. The coverage is at 98.3%. When analysing the whole project that…
MlaKe
  • 39
  • 2
  • 9
0
votes
1 answer

Imputation for longitudinal data using observation before and after missing data

I’m in the process of cleaning some longitudinal data and I have several missing cases. I am trying to use an imputation that incorporates observations before and after the missing case. I’m wondering how I can go about addressing the issues…
Jonah M.
  • 5
  • 1
0
votes
2 answers

Finding related date to Calculated Measure in MDX

BackStory I am working in MDX and my measure groups use many calculations. Many of these are timeframes such as [Date].[Fiscal].[LY WTD] which stands for last year week to date. To calculate this I was using the ParellelPeriods function. However as…
Jacob Lynn
  • 9
  • 5
0
votes
1 answer

Sorting all the columns in MDX queries

Below is my MDX query. Here I have applied sorting for one column, how can I sort all the columns, the reason behind this is, I no column should have any values like (null), null, empty, unknown etc. WITH MEMBER PageSize AS 1 MEMBER [PageNumber]…
Sibeesh Venu
  • 18,755
  • 12
  • 103
  • 140
1 2
3
4