Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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] ) )
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
13 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
20 | |
14 | |
11 | |
10 | |
10 |