9,735 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
25
views
CALCULATETABLE inside SWITCH in DAX
I have written the following DAX Measure:
Source Total Revenue - All Revenue - COSStoRevenue =
SUMX(
VALUES('Date Table'[Year Month]),
VAR IndST = SELECTEDVALUE('Individual Cost'[Cost Type])
...
0
votes
0
answers
40
views
How to change Table Row category based on Slicer?
I have a data model ("mainModel") loaded, and among the columns are "Parent Company" and "Sub-Companies" (in addition to many other columns, eg. "Values", "...
Advice
0
votes
2
replies
25
views
Dynamically display values on a ribbon chart controlled by a slicer
I want to be able to use a slicer on a ribbon chart that will dynamically display the values in millions/thousands. One total is quantity and the other is price. The chart will display yearly totals ...
1
vote
1
answer
83
views
Cumulative DAX measure only works as expected when a date slicer is present
In Power BI, I have a semantic model with a fact table and a date table (marked as date table).
I have three measures.
One simply totals a column in the fact table: SalesAmount = SUM(FactInternetSales[...
1
vote
1
answer
87
views
Save DAX Expressions for later PowerBI Dashboards?
Is there some way to store commonly created DAX Expressions/Measures for use in multiple files?
I have a dataset that I refresh every month or so, and always have to manually add a few columns to the ...
0
votes
0
answers
56
views
DAX cumulative measure returns incorrect last month total when trying to optimize
I'm working on a Power BI report where I need to calculate cumulative account balances (OpenAccountsRunning) based on a per-month snapshot measure ([BaseClosing]).
I originally wrote this "fast" ...
0
votes
1
answer
124
views
DAX Query Filtering
I have one table(final Table) which has columns (date, volume, Month, resource) where I'm calculating the utilization of a resource. so,I need to have time which gets calculated as per below formula ...
-1
votes
1
answer
37
views
Is there a way to dynamically scale Line chart with multiple measures in powerbi to improve readability? [closed]
My main goal is to improve readability of my chart based on selected measures to be able to tell trends better. just a normal scaling, is this possible?
here is link to my sample dataset and pbix.
...
Advice
0
votes
1
replies
35
views
Check last 12 months based on slicer
I need to make a simple check in a measure.
I have a table similar to this:
MonthYr
Flag
1/1/2023
0
2/1/2023
0
3/1/2023
0
4/1/2023
1
5/1/2023
1
6/1/2023
0
7/1/2023
0
8/1/2023
0
9/1/2023
0
10/1/2023
0
...
-1
votes
2
answers
74
views
Reference Slicer option in Calculated Column
I am trying to anonymize data, except for the company that's selected in a filter.
Sample data is below:
Company Name
Anonymous Name
[Calculated Column]
Coca Cola
Company A
Wayne Enterprises
Company B
...
0
votes
0
answers
30
views
Calculating the year to date sales of the previous year in a matrix visual
I have a matrix visual which is based on a view v_Umsatz. The visual uses the year as the columns and the customer as the rows. For every year I want to calculate the sales amount up until the current ...
Best practices
1
vote
0
replies
33
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
vote
1
answer
55
views
Creating a Basket Analysis that Customers who buy X also LATER bought Y
I am trying to make a visual in Power BI that shows me what people order second, if they order x product first. Very similar to a basket analysis but I don't want to know what was in the same cart as ...
0
votes
1
answer
46
views
Calculating working days considering different weekends - Power BI DAX
I want to calculate the "working days" between 2 dates in Power BI. Middle east and north africa countries have different weekends (for example Egypt and Saudi Arabia Fri,Sat, the rest Sat, ...
2
votes
2
answers
122
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, ...