Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
The measure results are incorrect for certain rows. I don't understand why. Please let me know how I can resolve this. Also the totals are wrong as well.
DAX command =>
Solved! Go to Solution.
@PMnooBI Why not:
Spent =
VAR __Hours = SUM('BTA Hours'[Hours Billed])
VAR __Rate = RELATED('BTA Hourly Rate'[Hourly Rate ])
VAR __Result = __Hours * __Rate
RETURN
__Result
At least that way you can troubleshoot and debug it.
Hi @PMnooBI
Apparently these rows are an aggregation of multiple rows of the 'BTA Hours' table. The 185 represents two rows, the 555 represents 3 rows and so. Either these rows are duplicates or you need to include more columns in the table visual to make sure only row level is represented in the visual without any chance of aggregation.
Hi @PMnooBI
Apparently these rows are an aggregation of multiple rows of the 'BTA Hours' table. The 185 represents two rows, the 555 represents 3 rows and so. Either these rows are duplicates or you need to include more columns in the table visual to make sure only row level is represented in the visual without any chance of aggregation.
@PMnooBI Why not:
Spent =
VAR __Hours = SUM('BTA Hours'[Hours Billed])
VAR __Rate = RELATED('BTA Hourly Rate'[Hourly Rate ])
VAR __Result = __Hours * __Rate
RETURN
__Result
At least that way you can troubleshoot and debug it.
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |