Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Kindly asking for help.
I want to add (or count) certain columns with reference to a column containing whole numbers (1, 2, 3, 4...). The outcome will be based on a filter (single select from [1, 2, 3, 4...]).
The logic is:
Normally in Excel the formula will be: '=SUMIFS(<Value_to_Add_Column>,<Reference_Column>,"<=" & <Reference_Number>)
For the below screenshot: =SUMIFS($B:$B,$C:$C,"<="&$E2)
Thank you!
Try
Total Amount =
CALCULATE (
SUM ( 'Table'[Amount] ),
'Table'[Group number] <= SELECTEDVALUE ( 'Group table'[Group number] )
)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
11 | |
10 | |
8 |