Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi, I have a raw data set where there are multiple lines for each Project ID and Country.
I then grouped this data by Project ID & Country (Market), and aggregated all NTSLC$ values. This is my "Proj Aggregation Test" table in powerBI.
However, when I create a table in PowerBI, and put the financials, it is giving me the TOTAL value instead of the sum of each line item (eg. first row should be the total financials of the 2 projects in that bin)
How do I write a DAX to sum only the rows???
Solved! Go to Solution.
NTSLC SUMS =
VAR selectedRangeMin = SELECTEDVALUE('Proj Value Rank'[MinValue Range])
VAR selectedRangeMax = SELECTEDVALUE('Proj Value Rank'[MaxValue Range])
IF (
HASONEVALUE ( 'Proj Value Rank'[MinValue Range] ),
CALCULATE (
SUM ( 'Proj Aggregation Test'[Sum NTSLC] ),
FILTER('Proj Aggregation Test',
'Proj Aggregation Test'[Sum NTSLC] => selectedRangeMin &&
'Proj Aggregation Test'[Sum NTSLC] < selectedRangeMax
)
)
)
NTSLC SUMS =
VAR selectedRangeMin = SELECTEDVALUE('Proj Value Rank'[MinValue Range])
VAR selectedRangeMax = SELECTEDVALUE('Proj Value Rank'[MaxValue Range])
IF (
HASONEVALUE ( 'Proj Value Rank'[MinValue Range] ),
CALCULATE (
SUM ( 'Proj Aggregation Test'[Sum NTSLC] ),
FILTER('Proj Aggregation Test',
'Proj Aggregation Test'[Sum NTSLC] => selectedRangeMin &&
'Proj Aggregation Test'[Sum NTSLC] < selectedRangeMax
)
)
)
Where is the Value Range Column and how is it connected to your data?
Hi @lukiz84 ,
My Value Range column is from a separate table called "Proj Value Rank" (not connected to any tables):
I used this message to group projects into bins using this link:
https://www.burningsuit.co.uk/blog/dax-how-group-measures-numeric-ranges
This is my DAX measure based on the above link:
User | Count |
---|---|
21 | |
20 | |
14 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
13 | |
12 | |
11 |