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.

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

936 questions
0
votes
1 answer

SSAS & OLAP cube: twice same measure

I'm not very experienced in OLAP Cube + MDX, and I'm having a hard time trying to use twice the same measure in a cube. Let's say that we have 3 Dimensions: D_DATE, D_USER, D_TYPE_OF_SALE_TARGET and 3 tables of Fact: F_SALE, F_MEETING,…
Francois
  • 10,730
  • 7
  • 47
  • 80
-1
votes
0 answers

Measures is blurred out in powerBI

I can't use the calculations menu. The data is from a SQL server, and I'm wondering why I can't get access to use the measure function? I was thinking that it might be due to something with the relationships between the tables, but I'm not sure how…
Emilie
  • 1
-1
votes
1 answer

Power Bi Measures Showing blank

I have written this DAX query to calculate the 90th and 75th percentiles of my dataset. However, I am encountering an issue where the 90th percentile measure for RevPAR is displaying as blank, while the other measures are showing values. Similarly,…
-1
votes
1 answer

I want to assign numbers to rows of data and filter by summing those numbers

I have multiple tables and each table contains names of staff and answers to different appraisal questions. When staff has answered any appraisal question, an appraisal date is entered in the table. What i want to do using DAX is to look at each…
-1
votes
1 answer

Power BI Dax Measure moving Sum by categories

im struggling with the following problem. I have categorical variables and and Amount column. What I want to do is, to write a dax measure which calculates the moving/rolling Sum, like you see in the third column "Dax Measure". Did not find any…
bonus
  • 1
  • 3
-1
votes
1 answer

How do I create a 12 week moving average in Power BI that accounts for stores open less than 12 weeks?

I work for a retailer and made a rolling 12 week sales average the brute force way. More specifically, I made 12 measures to calculate the average for my 12 weeks individually. Then a 13th measure to average my 12 weeks. That said, if a store has…
m5edward
  • 25
  • 8
-1
votes
2 answers

How to do a measure %?

Team, I'm trying to create a measure so I can pull over our Maintenance and repairs by % of revenue: Z - Maint/Repairs % = sum('LSI DP_JP_HistorySummaryBySiteMaster'[Maint/Repairs]/[Z - JP TTM Rev. Copy]) I receive this error: 'The SUM function only…
Chasity
  • 27
  • 4
-1
votes
1 answer

Consecutive Absent/Worked Days Power BI Measure

I am current trying to Dynamically Calculate Consecutive worked and absent days for a group of employees, however this as proven to be quite a difficult task. The RAW table looks something like…
Puno
  • 61
  • 9
-1
votes
1 answer

measurement with python from foot and inch to meter and centimeter

Hello guys I want to make a program that invert the measurement At the first, the user input two or three numbers and the inverting is going to meter and centimeter but it's not showing the correct answer the only answer is 0 I would be so thankful…
Javad B
  • 1
  • 1
-1
votes
2 answers

DAX measures cannot find all tables

I’m writing my first DAX measure. When selecting the table , I cannot find all my tables ? Is there any reason why ? (Transaction table not found)
Tarek Tarek
  • 1
  • 1
  • 1
-1
votes
1 answer

How can i "delay a program" without delay?

So I am "playing" with an Arduino Uno R3. With an ultrasonic sensor and LED's I programmed the Arduino to measure a distance, and if it gets too close to something, the LEDs start to shine one by one. Now I want to implement a buzzer that beeps in a…
-1
votes
1 answer

Ratio instead of existing values

I am trying to find the ratio for two values in a visualization. How many "light blue values" for every "dark blue values". I would like the visualization only to show a stacked column with this info. e.g 1.2 as a ratio. How tried performing a quick…
Kaizan
  • 43
  • 6
-1
votes
2 answers

Measuring time to generate better random numbers in c++

I am teaching myself programming, and as a challenge I tried making a simple text battle system in c++. I used the function rand() to generate pseudo-random numbers. The problem is, they were the same every time you ran the program. e.g. If num1 was…
-1
votes
1 answer

why do'nt super.onMeasure or textView,setText() trigger measure pass again?

I have some android code of a custom FrameLayout. The code changes some textView text. I see the change take effect only when i call super.onMeasure(...,...) I would expect it to call onMeasure() automatically when the text change via code or when I…
Elad Benda
  • 35,076
  • 87
  • 265
  • 471
-1
votes
1 answer

Maximum possible measure and dimension in SAP UI5 Viz Chart (Line, Stacked Bar, etc.)?

Working with SAP UI5 Viz chart (Line, Bar, Stacked-bar, pie, waterfall etc.). I am trying to make Line chart with 4 measure with 2 dimension and Stacked-bar with 5 measure with one dimension. But in Line can see only two lines (but 4 measure title…
Suman Biswas
  • 169
  • 3
  • 7
  • 20