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.
How to show sum in total of a column having minimum values from dataset ?
Thanks in advance
Solved! Go to Solution.
Hi @gondal786
you can create new measure
SUMX (
VALUES ( TableName[LOAN_APP_SEQ] ],
CALCULATE ( MIN ( TableName[OST] ) )
)
Hi @gondal786
you can create new measure
SUMX (
VALUES ( TableName[LOAN_APP_SEQ] ],
CALCULATE ( MIN ( TableName[OST] ) )
)
I tried it earler its ok at row level but show incorrect value in total (ost_tt_measure), I wanna column sum in last total row rather as minvalue.
I'm using table / matrix both as per requirment.
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 |
---|---|
107 | |
100 | |
85 | |
77 | |
66 |
User | Count |
---|---|
120 | |
112 | |
94 | |
84 | |
75 |