Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to add a new measure of MIN for the column Target and Plan. Could anyone help me with this?
Particular | Plan | Target |
ABC | 67669 | 54618 |
YTD | 161083 | 731453 |
DSF | 15224 | 951020 |
NJN | 884000 | 611637 |
KSM | 56752 | 5785165 |
AMC | 30009 | 4059145 |
NJN | 5866023 | 1328 |
LML | 2565 | 257224 |
AAA | 941904 | 4356724 |
ALL | 27493145 | 1045457 |
OIL | 7987624 | 4586814 |
MNH | 3210656 | 316924 |
EGG | 1491850 | 1407924 |
JULY | 1185545 | 408045 |
SHE | 90309 | 4316124 |
If [Target] and [Plan] are measures then
MINX (
ALLSELECTED ( 'Table'[Particular] ), [Target]
)
@Mayank09sharma , Are you expecting this?
Min of Plan= MIN('Table'[Plan])
Min of Target = MIN('Table'[Target])
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |