1,214 questions
1
vote
1
answer
2k
views
Power BI - Set custom Y axis unit label
In a Power BI (working in Power BI-Desktop) line chart, I am charting a field that lists KBytes of data (Y axis) that was backed up on particular weeks (the X axis). The Y axis auto-generated hash ...
1
vote
1
answer
94
views
How to Create a Measure that works Against Whatever the Selected Row Is?
I have a simple table in Power BI Desktop:
| Total | YTD
=======|=======|======
Sally | 100 | 20
Bob | 15 | 3
Joe | 47 | 36
=======|=======|======
Totals | 162 | 59
I ...
- 66k
0
votes
1
answer
36
views
Relationship between dimension and measures
There is a Fact Table (.....,MenuID, MOption, CallTime)
There is also a Dimension "Menu" Table (MenuId,OptionID)
Relationship between these tables (MenuID and MOption)
In the Dimension table,...
0
votes
0
answers
123
views
Issue with DAX Calculate Measure working and not working randomly
Example Image
I have a DAX measure that calculates Quote Quantity Remaining by subtracting delivered quantity from quote quantity (i.e. i quote you for 10, you buy 4, 6 are remaining)
My issue is ...
1
vote
2
answers
69
views
Group charge periods by MAX and MIN voltage, per device in Power BI
I have a large data table containing voltage information for hundreds of remote devices. These devices report voltage every ten minutes, and they are charged daily. Charging can start the previous day ...
- 2,112
1
vote
1
answer
44
views
rounding into milions in dax
I have a code as below and i would like to round it. How to get around with this ? Many thanks in advance.
var _result =
SWITCH(
TRUE(),
ABS( _sales ) >= 1000000, FORMAT( _sales,...
- 3,031
1
vote
1
answer
2k
views
DAX Group by and Sum
I am away that this question has already been asked, but the solutions I have found so far did not work.
I have a Dimension table with a business key, lets call it FacilityBK, and a number of ...
- 536
2
votes
1
answer
53
views
Filter calendar based on today's date in powerbi
I have a dim_calendar as below and I would like to create a measure to show the current month and Fiscal year on a powerbi Card. Many thanks in advance.
Date FY Month Year
11/19/2023 ...
- 3,031
1
vote
1
answer
512
views
How to show only column subtotal in power bi table?
I have a table like and I would like to see only the subtotal column. Is this even possible in power bi ?
- 3,031
-1
votes
1
answer
174
views
Issue with date slicer and COALESCE function
I have a matrix table witch is filtered with a Date lookup table, which works fine:
Currenly filtered from June to November.
I then created the following function:
satisfactionRate =
VAR SatRate =
...
- 1,380
1
vote
1
answer
101
views
count non blank rows based on a condition in Dax
How to set a filter in two different columns then count the remaining rows in Dax.
measure = CALCULATE (
COUNTROWS( df )
,df[column1] IN { "col1", "col2&...
- 3,031
1
vote
1
answer
620
views
Exclude dates from Date Table which are not available in the fact table
I have a between slicer which gets the dates from my Date Table (Table contains earlier dates that the data from the Satisfaction table).
The slicer includes all the dates from my Date table, I would ...
- 1,380
1
vote
1
answer
99
views
How to format numbers in DAX, based on a condition
I have var _sales and I would like to format it based on its decimal numbers.
Expected Answer:
If the number is `15.506,514 Million` = `15 M`
`15.606,514 Million` = `16 M`
How to get around the code ...
- 3,031
1
vote
1
answer
257
views
How to Filter a Disconnected Table
I have a main table (Table 1) and I have created another table which is called rangeBefore (Table 2):
rangedBefore (Table 2) =
FILTER (
SUMMARIZE ( 'Campaign Overview', 'Campaign Overview'[campaign],'...
- 1,901
0
votes
1
answer
20
views
MDX calculated measure 2022 Vs 2023 units
i have a pivot table with 2022 and 2023 shipped units cols.
Looking to use an MDX calculated measure to calculate the index of these (2023/ 2022)*100
I have a calander table with year and 2022 and ...
- 9
-1
votes
1
answer
67
views
Power BI: Filter a table based on measure with multiple OR's
I am trying to filter a table based on the measure pasted below. A row from the table 'sheet1' should be shown in the table if:
the column 'parent link' contains the string as defined AND
the column '...
- 13
1
vote
1
answer
105
views
Remove rows based on ifelse statement in Dax
I am trying to create a measure to prevent double counting. The dax code below works fine unless [LC or USD] = "USD". I need to remove the rows when [LC or USD] = "USD" holds. How ...
- 3,031
0
votes
1
answer
287
views
Employee count with several rows per employee (different departments)
I have a table (EMP) of all employees as like the example below.
EMP_ID
Department
Dep_Start_Date
Dep_End_Date
1
A
2019-05-01
2099-12-31
2
A
2019-10-01
2021-04-10
2
B
2021-04-11
2099-12-31
3
C
2022-09-...
- 3
0
votes
0
answers
32
views
Power BI Measure Changed by Filter
In Power BI I want to have a graph that shows the Average Age for any row where Open >= 60 when Type = A and Open >= 70 when Type = B. I have a slicer on the tab to choose between A or B and you ...
- 525
0
votes
1
answer
38
views
Power BI summing for one value, not summing for other
I have a formula in my DAX
Difference in Open WBS since last Qend =
VAR PreviousPeriodSum =
CALCULATE(
SUM('RA_Run_Time_Automatic_History'[Open WBS]),
'RA_Run_Time_Automatic_History'[Period Int] = 7
)
...
0
votes
1
answer
413
views
Calculated Column in Power BI using Paramaters in IF Statement
I am trying to create a custom column called "Min" and want the selected value for each parameter within the IF statement to output when the statement is true. Whenever I do the IF statement,...
- 13
0
votes
1
answer
723
views
CALCULATE with REMOVEFILTERS result altered by slicer or filter pane
TL;DR up front:
A normal CALCULATE with REMOVEFILTERS that works as expected does weird things (impossible values) when there is a visual-level filter applied AND a slicer is used (as in, a value is ...
- 109
1
vote
1
answer
447
views
Power BI: How to return values from one table based on slicers referencing another table?
I have a Power BI report with two tables in it. Table_1 looks like this:
ID
Country
Cost
Joining_field
MAR23
UK
20
MAR23_UK
MAR23
ROI
10
MAR23_ROI
JAN23
UK
25
JAN23_UK
JAN23
ROI
25
JAN23_ROI
...
- 521
0
votes
1
answer
116
views
Measures in a Column
I have 4 measures in Power BI that return a date. I want to show it in the power bi matrix as if it were a column. What I can do?.
The matrix already has rows and values but I need the dates of ...
user18729535
-2
votes
1
answer
2k
views
Current Month, Previous Month and YTD Count in card in Powerbi
I need to create a card in which I have to show below numbers:
Current month count
previous month count
ytd count (should start from last year 1st dec)
I have table in which have a column called ...
