Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Modify Values

I have a table with following numeric values:     A   B   C WN 112.00    256.00   198.00 TD 3.96   5.634615   4.506757 OD 4.00   5.530435   4.320175   How to ge...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    I suggest unpivotting the table like below, and write the measure like below.

     

     

    Result: =
    SWITCH (
    SELECTEDVALUE ( Data[Category] ),
    "WN", FORMAT ( SUM ( Data[Value] ), "#,##0" ),
    "TD", FORMAT ( SUM ( Data[Value] ), "#,##0.00" ),
    "OD", FORMAT ( SUM ( Data[Value] ), "#,##0.0" )
    )

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

I suggest unpivotting the table like below, and write the measure like below.

 

 

Result: =
SWITCH (
SELECTEDVALUE ( Data[Category] ),
"WN", FORMAT ( SUM ( Data[Value] ), "#,##0" ),
"TD", FORMAT ( SUM ( Data[Value] ), "#,##0.00" ),
"OD", FORMAT ( SUM ( Data[Value] ), "#,##0.0" )
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you Jihwan_Kim!