9,731 questions
Best practices
1
vote
0
replies
27
views
Power BI slicer based on value in one columns and condition that this value is not available in related table
I have two related tables:
SD with columns: No, Date, etc.
Orders with columns: SDNo_, Date, etc.
Both are related with this No - SDNo as one SD to many Orders.
There some No, which are present in ...
-1
votes
0
answers
19
views
Matrix PBI presentation with monthly YTD vs YTD-1
In PBI, I need to create a matrix that, based on the selected month:
Display the data for the current month and the data for previous months of the same year.
Display the data for the months of the ...
- 19
2
votes
2
answers
103
views
Rank (TopN) within Group
I have a table of data, and I want to sort by STATE, and then for each STATE, return the TopN (say Top 3 for example) COMPANY per state.
Using the generic visual filter for Top 3 Company, by Value, ...
- 23.5k
0
votes
0
answers
30
views
Writing a calculation group designed to make a slicer inactive
I have a slicer on PeriodSlicer[Period] for All Time, Full Year, Year to Date and Selected Dates.
Selected Dates should apply whatever dates are selected in the Calendar slicer, while the others ...
- 264
0
votes
0
answers
44
views
How do I create a dynamic title with a multi-select slicer to display when single, multi, and all selected?
I am attempting to create a dynamic title that will return the category when 1 item is selected, return multiple options separated by a comma when they're selected, and return "ALL" when ...
0
votes
0
answers
51
views
Elegantly suppressing aggregated data points in a clustered column chart representing fewer than a given 'n' of records
I have a fairly large (long) dataset that looks something like this... one record per individual response to each part of each question:
ID
breakdown_1
breakdown_2
question
question_A_or_B
value
1001
...
-3
votes
1
answer
38
views
grouping of items sales price with with qty sold and total sales [closed]
I need help in recreate the report that's done in MS Access in Power BI.
I'm trying to get the quantity sold, total sales amount, etc. by the item sale price that fall into the different ranges.
All ...
- 67
0
votes
0
answers
37
views
Rank Function - by measure over multiple columns
I want to make a measure that returns the rank of the current Reason×Resource by [Qty_Sum], respecting page/report slicers.
Qty_Sum =
[Qty_2025_W38] + [Qty_2025_W39] + [Qty_2025_W40]
...
- 83
0
votes
0
answers
22
views
Power BI Dax Measures Renaming AUtomation
I have recently started working as a Power BI Developer. I was given a task of renaming dax measures present in the model. There are more than 50+ dax measures. Now the task is to automate this ...
- 1
1
vote
0
answers
62
views
Error occured while running DAX in Power BI which is connected to SSAS using live connect mode
I have connected my SSAS with MS Excel and all the dax which i am running is working fine .
Image of DAX result in MS Excel
But when i am connecting the SSAS with Power BI it is not running as ...
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
1
vote
0
answers
55
views
DAX Year To Date Cumulative Total
I am fairly new to DAX and am coming across a problem I cannot solve.
I have a SSAS Tabular Cube and am trying to create a YTD cumulative total which, fort the most part, works as expected. However it ...
- 11
0
votes
0
answers
29
views
How to prevent jumpback on user input in deneb vega gantt chart?
I am trying to create a Vega Gantt Chart using the template from David Bacci - Deneb-Showcase.
In my original dataset I am taking the data from sharepoint and importing it into deneb visual. I did ...
- 25
0
votes
1
answer
41
views
How to update a Power BI Template
Months ago I have downloaded the:
Microsoft Fabric Capacity
Microsoft Fabric Chargeback Reporting
The version I have are the following:
It seems to me that I have a discrepancy between my version ...
- 12.8k
0
votes
2
answers
57
views
SSAS Tabular grand total wrong with hierarchy filter
I am using SSAS Tabular 2022 and has model as below:
The total amount is calculated as
Total Amount:= sum(Amount[Amount])
When I view in Excel and filter the model by the Year-Month-Date, the first ...
- 9
0
votes
0
answers
28
views
Creating a Line graph & Matrix showing % Difference from Previous Year, allowing for a filter on "Country"
I have raw data with columns "Year", "Period", "Country", "Sales Amount". Please note there are 13 periods in a year, (and not 12). The dates also differ ...
- 1
2
votes
1
answer
68
views
Issues with DAX measure not showing row values in the table
I have a DAX measure that tries to find the previous weeks target and is used to subtract from the present week target to get me total change. The measure does not show any row values. It worked prior ...
- 31
1
vote
2
answers
123
views
Count consecutive rows in Power BI that have a value. Get start date and max grade from that group
I have a table with the following data:
record_id
visit_date
int_date
month
hb_ae
wbc_ae
anc_ae
plt_ae
ast_ae
alt_ae
arc_hb_ae
sched
10
9/9/2015
7/8/2015
1
2
Sched
10
10/9/2015
7/8/2015
2
2
Sched
10
...
- 397
0
votes
1
answer
54
views
Average (measure) based on most recent date
My Power BI model has a single table. I cannot create any new calculated table.
I need to develop 2 measures in the DAX language, one for Salary of an employee based on most recent effective date; the ...
- 465
1
vote
1
answer
117
views
Dax query with IN operator using multi valued parameter Power BI report Builder
I need to create filter for table using parameter(working on report in Power BI report builder). So I have one main dataset and one dataset for parameter values where also was created row for all ...
- 47
2
votes
0
answers
99
views
Matrix table in power bi
I have a table Feature_Site, I want to count the featureCode by FeatureStatusDescription, I already have a measure that gives me the feature count
Totl_features =
COUNT ( Feature_Site[FeatureCode] )
...
- 57
0
votes
1
answer
43
views
DAX calculation
What DAX calculation to calculate the Sales $ Fulfilled where Is Originating Online Sales Store = "Y" and match the Fulfilling Location to Originating Location
Meaning, any sales that were ...
- 141
1
vote
0
answers
91
views
Optimizing DAX code (Query exceeding resources error)
For this DAX, I can select individual Items one-by-one and it will populate an actual rate. The issue is a select all situation. If I wish to see all locations Actual Rates, The query exceeds ...
3
votes
2
answers
132
views
How to join two tables when one table has filters to applied to the second one?
I have these two tables:
+-------------------+ +-------------------+
| TAB1 | | TAB2 |
+---------+---------+ +---------+---------+
| PRODUCT | ACCOUNT | | GR | ...
- 31
0
votes
1
answer
83
views
Counting Unique Events Within Specific Date Range
I have a data table that captures information on events, using three key columns to identify events by their "Incident Date", "Incident Name", and "Space Name". Using dax ...
