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.
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])
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 |
---|---|
43 | |
26 | |
20 | |
14 | |
8 |
User | Count |
---|---|
73 | |
47 | |
45 | |
17 | |
17 |