1,214 questions
0
votes
0
answers
52
views
Measure shows total but isn't working on granular level in table
I need to calculate project budget in my table visual which should displays its total budget completely irrespective of any Period Year filter applied by the user. Below measure is working fine for ...
- 57
0
votes
1
answer
33
views
Calculating the right ratio in a matrix with subrows in Power BI and DAX
I'm dealing with the following situation in Power BI.
I have a matrix where:
Rows contain client names (sales[cardname])
Subrows contain the products related to each client (sales[itemname])
I'm ...
- 1
3
votes
1
answer
49
views
How to create measure to get last salesperson to sell a product with date slicer altering filtering the sales transactions?
Given I have a products table and sales table as below;
Product ID
Product
1
Roller Skates
2
Bicycle
3
Monitor
4
Keyboard
ID
Product ID
Sales Person
Dated
1
2
Peter
2025-03-12
2
1
Brian
2025-03-14
3
2
...
- 93
0
votes
1
answer
55
views
Power BI measure for cumulative count/sum over all related rows at the current hierarchy level and below
I have this table say 'Table' with a column in Power BI that contains a piped path of strings such as 'Level1|Level2|...'.
This column is expanded into multiple fields [Level 1], [Level 2], ... ...
- 114
1
vote
1
answer
172
views
Cumulative total for the last 12 months
I'm trying to visualize sales for the last 12 months, but with a specific twist:
I have a year-month slicer (from a calendar table) that defines the last visible month.
The chart should then show 12 ...
- 65
3
votes
1
answer
39
views
Sum Values Which Appear In Both Tables
I have 2 related tables and I would like to sum if id number is exsist in the both tables.
table1
id sum
1 5
3 10
5 15
table2
id sum
1 10
2 20
5 30
Expected Answer
sum = 5 + 10 + 15 + ...
- 3,031
0
votes
1
answer
19
views
adding if statement in a Measure DAX
I am using the following DAX in the measure below:
UPS %No Maint Bypass =
VAR TotalMaintBypass =
COUNTROWS (
FILTER ( ALL ( 'UPS (2)' ), 'UPS (2)'[UPS Maintenance Bypass] = "TRUE"...
- 47
1
vote
2
answers
75
views
PowerBI: Filter for lowest column value in table visual
I have a table with multiple columns. Few include: Customer ID, submission date etc. I have created a DAX column measure to rank by customer id by submission date. Eg If customer A has submitted 3 ...
- 11
-2
votes
1
answer
47
views
combine two date columns - sort of Role Playing Dimensions
I have a scenario in Power BI:
I have a simple Transaction Table, with Order and Delivery years in two columns, with an Amount column.
I do not care about the ProductId column for my visuals; the ...
- 465
-1
votes
2
answers
96
views
Power BI show last figure in data column in card visual
I have the need to show the latest figure in a dataset within a card visual. This data is added to each month so i have a need to only show the latest month. I've currently got this measure but it ...
- 183
1
vote
0
answers
49
views
Measure PWM Duty Cycle with Pic
I am trying to measure two PWM input signals and, based on them, turn a LED on or off. I am using a PIC16F18313 microcontroller.
I have a Futaba remote control, and through its receiver, I receive two ...
0
votes
0
answers
71
views
Excel Pivot Chart of Dynamic DAX measures not working
Working in Excel (Microsoft Office LTSC Professional Plus 2021)
I am trying to plot some measures using a pivot chart object but as far as I could investigate, it seems what I am trying to do it is ...
0
votes
0
answers
52
views
Dynamic Measures in a Matrix
Afternoon all, am having trouble with matrixes and a multitude of measures.
Data Structure
Sales Table
Calendar Table (incl. Calendar year and fiscal year that runs from
01/10/20xx to 30/09/20xx
...
- 35
0
votes
1
answer
87
views
PowerBi measure where the total is based on the legend and adjusts total for selected slicer
I have a table in PBI that looks like this:
ID
Name
Date
Performance
Country
Region
1
Joe
12/31/2023
Good
UK
Europe
2
Anna
12/31/2023
Needs Improvement
Spain
Europe
3
Robert
12/31/2023
Good
Japan
Asia
...
- 13
1
vote
1
answer
112
views
Message that says "there is no data" if no records in report
I'm replicating our reports from Qlikview and there are 2 specific ones that sometimes don't have any records for a specific day. With Qlik, there is a message on the distributed report as shown in ...
- 11
2
votes
1
answer
81
views
Get Average of Top 3 in a Summarized Table in Power Bi
I'm new to Power Bi and I'm facing a problem. I have Sales table in which there is column named Moony. The table is like this:
RowNumber
Moony
Volume
1
140309
123456
2
140309
15616
3
140210
565
4
...
- 149
0
votes
1
answer
88
views
Combining a title measure to also show an image next to the string in Powerbi?
I have a custom tooltip for my PowerBi map, which shows when you hover over a specific sourcing area on the map.
Currently, the top card has the following measure
_MAPTITLE = SELECTEDVALUE('Volumes'[...
0
votes
2
answers
113
views
How can I display each ID only once based on their latest date by selected period?
I have a PBI challenge. The user wants to see each ID in Dynamic Date Chart but for their latest date BASED on the date filter.
For example, my table with columns:
ID
Date/hour
003
15-03-2024 14:00
...
1
vote
1
answer
81
views
Subtotaling a measure in an Excel pivot table
I know how I would handle this in SQL, but I'm being asked to do this in an Excel Power Query/Power Pivot, with which I am less familiar. I have medical data that looks something like this:
Doctor
...
- 13
1
vote
1
answer
71
views
DAX column totals are not giving expected totals when using the MIN
Name
Category
Item
Amount
Gary
food
rice
1
Gary
food
sugar
5
Gary
furniture
chair
8
Gary
furniture
table
4
John
food
rice
3
John
food
sugar
5
John
furniture
chair
6
John
furniture
table
7
Name
Food
...
- 75
0
votes
1
answer
51
views
Counting Measures in DAX in Power BI
I have a visualization in Power BI that reflects the category of a customer based on their market share. The market share is a DAX Measure which changes dynamically based on the selections in slicers (...
-1
votes
1
answer
1k
views
DAX Measure to Calculate Previous Year Values for Each Year in Power BI
I'm trying to create a DAX measure in Power BI that will calculate the value for the previous year based on each year present in my table. I want to create a list that shows the value for each year ...
- 9
0
votes
1
answer
368
views
The top 5 highest values PowerBI measure
I need help with a measure that should always show the top 5 highest values. However, when I select a country, cities from that country are added, resulting in more than 5 values. Any ideas why this ...
- 9
1
vote
1
answer
134
views
Reference Columns in a Virtual Table in other function
I need to first group by my data by date and then calculate second quartile.
I used the function SUMMARIZE()
But I cannot refer the virtual table column as an argument in the PERCENTILE.INC() and ...
- 55
0
votes
1
answer
199
views
How to fix PowerBI formula - DAX has red line with no error code
I am trying to run some analysis, and typed a formula to attempt to do so, but the DAX is giving me the redline error, with no error message.
I have no idea why this formula wont run, so any ...
