The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Facts:
I have this table in which 'See below' rows (marked in yellow) should see the sum of values which are under see below in that group. For example, for first group the sum is 37,534,098,814 (18,343,557,949 + 19,034,919,257 + 155,621,608).
Record check is a calculated measure.
Problem:
'See below' rows (marked in yellow) should sum only the rows where the record check is 1. For example, the sum should be 19,190,540,865 (19,034,919,257 + 155,621,608).
Please help... I am stuck from last 2 days on it... @Greg_Deckler
@b_inder
Record Check 1 =
CALCULATE (
SUM ( 'Table'[Estimated Value] ),
FILTER ( 'Table', 'Table'[Record Check] = 1 )
)
##################################
@b_inder THANK YOU!!
Hi, thank you for your reply... But may I know which column is 'sub' in the bench measure calculation?
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |