Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all and thank you for any advice
Relatively new to all this and have hit a wall! I am working with SQL as my data source and I have three tables, filtered by the slicer.
The name is me so not too worried that is showing! The first table is a countrows of the class code, the second is a countrows of user id in those classes. The third contains a measure that multiplies periods by pupils, by class. All good so far. The totals in the first two tables are fine, and I understand why the total in the third table is what it is, but that is not what I want. My plan is to turn the total off in the third column and what I would like to do is have the sum of the commitments column of the filtered data in a card.
I have read quite a few posts but struggling to make sense of it all.
ANy help gratefully recieved.
Apologies if I have waffled!
Solved! Go to Solution.
If you're not using a measure then you need CALCULATE to force context transition. Try
Commitments by class v2 =
SUMX (
VALUES ( 'Timetable Schedule'[txtCode] ),
CALCULATE ( COUNTA ( 'Set Lists'[txtSchoolID] ) )
* CALCULATE ( COUNTA ( 'Timetable Schedule'[txtCode] ) )
)
Amazing, that worked!!! Thank you so much.
I think you want something like
Commitment by class =
SUMX ( VALUES ( 'Table'[Class] ), [Pupils] * [Periods] )
Thank you for your help so far. I went with
If you're not using a measure then you need CALCULATE to force context transition. Try
Commitments by class v2 =
SUMX (
VALUES ( 'Timetable Schedule'[txtCode] ),
CALCULATE ( COUNTA ( 'Set Lists'[txtSchoolID] ) )
* CALCULATE ( COUNTA ( 'Timetable Schedule'[txtCode] ) )
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |