# Questions tagged [measure]

Measuring means to determine how big is a certain entity. In computing, it's often referred to calculating the size(s) of a screen.

**0**

votes

**0**answers

18 views

### How can calculated variance between months with MDX

I want calculated variance of PeriodsToDate between months with MDX.
For calculate Sum Amount i use thsi query : SUM(PERIODSTODATE( [DATE].[MONTH].[All],[DATE].[MONTH].CurrentMember),
[Measures].[...

**1**

vote

**1**answer

41 views

### Running Totals with Filters in MDX?

I want to start running-total from the date I choose in filter in Power BI, because all functions MDX I have tried, start running-total from the first value.
Like in the image I have shared I want ...

**1**

vote

**1**answer

64 views

### Manipulating last two rows if there's data based on a Cut date

This question is a slightly varied version of this one...
Now I'm using Measures instead of Calculated columns and the date is static instead of having it based on a dropdown list.
Here's the Power ...

**0**

votes

**0**answers

6 views

### Create measure dictionary for area annotation in iText

The supposed value for this would is 15.2 sq cm. however, when annotation is moved, it becomes 0.04 sq cm.
I got this data from my application where area is computed as 9658.6572265625 and its ...

**0**

votes

**2**answers

44 views

### Running Total in MDX

Hi guys I need help I want this result i have trying different queries with MDX in SSAS but doesn't work.
Thank you !

**0**

votes

**0**answers

8 views

### How to Measure Developers Tools to Evaluate Changes

I'm working on a project that has lots of development time tools. This is an Electron app that uses several external applications (some we also develop and some off-the-shelf) to run.
This includes ...

**0**

votes

**0**answers

46 views

### How to count the number of occurrences in another table with condition in power BI?

I'm trying to implement in Power BI what I did in an Excel file but I am facing some issues. I would like to manage calculations in Power BI in order to avoid calculation in Excel.
So, I have 3 ...

**0**

votes

**0**answers

21 views

### replicate a SQL report in powerbi - create 2 queries and merge them to get result

I am trying to create a report in power BI where I have to create one query which creates 30 calculated columns, then merge it with another query with left outer join to get my results. I am using ...

**0**

votes

**1**answer

61 views

### How to figure out whether the operation is CPU intensive or not

I have some code to review:
Task.WhenAll(contracts.Select(x => Task.Run(() =>
{
// here some 30 lines of synchronous code
}))).GetAwaiter().GetResult();
My thought that this code is ...

**2**

votes

**1**answer

29 views

### f-score: ValueError: Classification metrics can't handle a mix of multilabel-indicator and continuous-multioutput targets

I am trying to compute the micro F measure for a prediction my model did. I trained the model using word2vec Vectors with Keras and Tensorflow. I use the scikit library to compute the mirco F measure.
...

**0**

votes

**1**answer

37 views

### Creating measure dictionary for distance annotation

Creating a measure distanced annotation does not display the correct measurement unit, nor gives the correct calculation. Any idea which part I am doing wrong? or if there is some lacking data.
I am ...

**3**

votes

**1**answer

60 views

### real time vs. cpu time performance measure

I'm trying to do some performance measures in c++ by measuring the real elapsed time in milliseconds vs. the cpu time in milliseconds.
This is how my code looks like:
auto start = std::chrono::...

**0**

votes

**0**answers

43 views

### Power BI Matrix measure totals

I have a Power BI report that calculates the number of jobs due in a month and reports on how many jobs are completed on time. The report works well except the measure totals do not add up correctly ...

**0**

votes

**1**answer

31 views

### TypeError: f1_score() got an unexpected keyword argument 'average'

I'm extracting the F1_macro value using f1_score sklearn function.
I doing that for my Keras network, this is the code:
Y_dev_pred = self.model.predict([self.dev[0], self.dev[1]], batch_size=self....

**0**

votes

**1**answer

35 views

### Power BI relativity measure with mutiple groups

I have a data that I simply create:
Col1 Col2 Col3 Col4
2014/1/1 A Y 10
2014/4/1 A Y 15
2015/1/1 A Z 15
2015/4/1 A Z 30
2014/1/1 B ...

**0**

votes

**0**answers

33 views

### Why is time.time() result decreases to 50.85 seconds? [duplicate]

I used the difference between the two time.time() calls to measure the time that my app takes to complete a network request. App is running at Debian server. The problem is that periodically I get a ...

**0**

votes

**2**answers

29 views

### Calculate product rate of previous day in tableau

I have a sample dataset:
DATE: 11-01-2015, 12-01-2015, 13-01-2015
SALE: $120, $0 , $100
In tableau I want if Today's sale is 0 as given above for 12-0-...

**1**

vote

**3**answers

67 views

### Measuring execution time when using threads

I would like to measure the execution time of some code. The code starts in the main() function and finishes in an event handler.
I have a C++11 code that looks like this:
#include <iostream>
...

**1**

vote

**1**answer

24 views

### Changing measure based on sheet

Is it possible to make a variable change in your measures based on the sheet that it is used in?
I have in about 15 measures and 3 sheets. The 15 measures need to vary slightly from sheet to sheet, ...

**0**

votes

**0**answers

37 views

### Measure effectiveness of algorithm (plot included for clarification)

I have written a short algorithm that computes the "comovement" of a time series. My problem is what method to use to measure how accurate this algorithm is. Ideally it should only have negative lines ...

**0**

votes

**2**answers

27 views

### Create Table from SUM of values from other tables

I have created measures called prev1, prev2, cur1, cur2 which are sum of numbers.
Then I created a table called using "Enter Data" button.
In the first column I have entered Item_A, Item_B
I am ...

**0**

votes

**0**answers

28 views

### Open Census and Unified code for Units of Measure

Short Version: What is the 1 unit in the unified code for units of measure?
In open census, a measure has a field named Unit -- which should be
a string descriptive of the unit of the Measure
AND
...

**0**

votes

**0**answers

28 views

### Read weight measure not get steady in Ionic

A Ionic app get weight measuring from a bluetooth Ardoino sensor. That works perfectly. But when i show the measuring it`s very unstable.
Now I have done this:
I get the values that come from data ...

**0**

votes

**0**answers

22 views

### How to define a GLM for repeated measures anova

I have data in the following format:
afex::aov_car(AVERAGEOFINDICATOR~ 1 Error(id/(YEAR)), data =mydata)
I need to check if the indicators and their average are significant over time or not. Is this ...

**0**

votes

**1**answer

20 views

### PowerBI - combining column function with measure

I have the following dataframe in PowerBI table:
mass (kg) number of boxes
10 2
blank 3
20 blank
blank blank
First row means that two boxes were delivered and ...

**0**

votes

**2**answers

14 views

### DAX Cumulative Window Function

I have the simple dataset as below:
I need to permit summing the DistanceTraveled column in a "Measure" given date filters selected, and date order, to allow a cumulative total. The data model is ...

**0**

votes

**0**answers

21 views

### Is there way to determine height of rectangle in centimetres, provided I know left, right, top, bottom co-ordinates?

I'm using opencv, I have left, right, top, bottom co-ordinates of a rectangle.
I want to measure width and height of the rectangle in centimeters. How do I do that?
I tried to find euclidean ...

**0**

votes

**1**answer

23 views

### Measure in power bi

I have this formula in qliksense now i want to do this power bi but this shows some error ..
I tried this
Total_Sales_Varaible = if('VBRK_BillingDocument_Header'[Billing Doc.currency_WAERK]="USD",...

**1**

vote

**1**answer

55 views

### How to detect plane surface using ARKit

I'm creating an app for measuring height of an object using ARKit. For small objects like bottle , pen and monitor it shows almost accurate result. but when am try for some large objects ie height of ...

**4**

votes

**1**answer

101 views

### Power BI - DAX Measure to calculate churned and reactivated customers in the current period. Incorrect total

Below is a simplified version of the data. Daily transaction list for customer ID
SalesData =
DATATABLE (
"Customer ID", INTEGER,
"Date", DATETIME,
"Amount", INTEGER,
{
{ ...

**1**

vote

**1**answer

62 views

### How to calculate value for each variable by their percent using DAX Power BI

Need your help to solved my problem about DAX Power BI.
So, I'm trying to visualize the total cost for each project that have employee on it using Power BI. but the cost for one employee can be ...

**0**

votes

**0**answers

37 views

### How to measure sound in decibels…keep getting 0.0dB

I tried using some resources from the web to build an audio recorder and also measure in decibels. I was able to record but upon measuring, all I get is 0.0dB. Why? What am I doing wrong? Please help.
...

**0**

votes

**1**answer

19 views

### how to create a measure YTD by mutiples items

On power pivot, I have difficulties to calculate YTD from a measure.
Total YTD is correct, however if I insert a column the YTD by item is not correct.
=IF (
HASONEVALUE ( Data[Year] ),
...

**0**

votes

**0**answers

9 views

### My fact table doesnt show some data in SSAS cube, how to bring all values from fact?

I have created the Year-Week Dimension and same has been used in my fact table too. I see data for 201839 and 201840 in fact table. But when I browse in Cube or pivot table I see data for 201839 but ...

**1**

vote

**1**answer

34 views

### DAX code change from calculated column to a measure

I have a fact table with settlement_date, product_id, service_id, location_id, and ticket_id and srv_adjusted_earning columns.
I have determined the DAX query to generate a calculated column that ...

**0**

votes

**1**answer

38 views

### How to make a (MDX) calculation in a SSAS cube to get the difference between a value from the current row and a value from the previous row?

I would like to make a calculation to get the difference between the departDate from my current row and the arriveDateNextStop from my previous row. I have a fact table which has multiple columns. The ...

**0**

votes

**0**answers

19 views

### SSAS Measure Weighted Average for distinct values in another colume

I have a fact table based on InvoiceAccountLines. In this table there are fields coming from the InvoiceHead (ex. InvoiceDate, DueDate, Supplier etc) which are the same for all InvoiceAccountLines ...

**0**

votes

**1**answer

84 views

### Power BI how using measure to rank for years columns

I using direct query and unable to create column, it there any way can using measure to create ranking for year column? eg: 2016 rank as 1; 2017 rank as 2; 2018 rank as 3; 2019 rank as 4;......

**0**

votes

**1**answer

93 views

### How to calculate based on different levels of a hierarchy - Power BI

Take the following matrix;
I need to know how to perform calculations on different levels of a hierarchy.
Say the Customer Service is Level2 of the hierarchy. (Level 1 being client)
The STDEVP....

**1**

vote

**0**answers

37 views

### Measuring parameters for the Universal Scalability Law for a NodeJS application running in docker

For my bachelors thesis (Software & Information Engineering) I want to apply the Universal Scalability Law (Neil J. Gunther, 1993) on a NodeJS microservices application running in a docker ...

**2**

votes

**1**answer

48 views

### SSAS OLAP Cube - Sum measure only works when keys are present

(This is a mock of my actual setup to help me figure out the problem.)
I have one fact table and one dimension table, linked by an id field.
My goal is to make a measure that sums up all "...

**0**

votes

**1**answer

163 views

### Power BI - Cumulative SUM filtered by current row values

I have a table with three columns - list_id, id, daily_return. id is basically a number sequence increment, reset for every list_id.
Example:
list_id id daily_return
1 1 0.2
1 2 0.18
...

**0**

votes

**0**answers

158 views

### Ignore visual filter while applying filter in measure Power BI DAX

I'm struggling with getting filters in Power BI to work properly.
I have created a Gauge visual where the value is a measure of Therapists count.
This measurement is to be filtered by slicers.
...

**1**

vote

**2**answers

105 views

### Measure in PBI with CALCULATE and FILTER

I have one report with 3 visual filters (date, country and type) and a table that list the stores and number of operatios with the aplied filters. I added a column with the number of operations that ...

**0**

votes

**1**answer

27 views

### Optimizing DAX Has X Amount or More in Time Frame

I am looking to speed up this calculation that takes a minute or two to load each time I add a different filter view on the page.
The base measure just calculates the total logins in a rolling 3 ...

**0**

votes

**1**answer

54 views

### Filter a column dynamically using a measure in Power BI

There is a column with FY i.e. "FY19","FY18","FY17" etc.
I Created a measure which calculates the current FY:
CurrFY =
CONCATENATE (
"FY",
IF (
MONTH ( TODAY () ) <= 3,
...

**0**

votes

**0**answers

29 views

### Can the iOS Measure App be invoked from within another App? [duplicate]

I have a requirement, where in my App workflow I have to invoke the Measure App, take the measurement and comeback to my App with the values.
I would like to know if this is possible? Is the URL ...

**0**

votes

**2**answers

61 views

### Web font size in cm

For my website I would like to set the font size in cm (centimeters), so that the font is readable independently of screen size and resolution, as long as display PPI (pixels per inch) setting is set ...

**2**

votes

**1**answer

67 views

### Construct lines from multiple 2D points and measure the distance between those lines

Multiple points on a 2D plane are given. They represent a window frame of mostly rectangular form with some possible variations. The points which are part of each side are not guaranteed to form a ...

**1**

vote

**0**answers

35 views

### How to find a threshold experimentally?

I computed the average of distances between each column and other columns in a matrix except itself. (the matrix is nxm size)
Then I plotted the distances and I'm trying to empirically obtain the ...