Hi, @Vnk
You can go through this regarding DAX calculation on KB and GB:
Total Used Space =
VAR total =
SUM ( Table1[Used Space] ) + 0
RETURN
IF (
total < 1024,
FORMAT ( total, "#0.0# B" ),
IF (
total < POWER ( 2, 20 ),
FORMAT ( total / POWER ( 2, 10 ), "#0.0# KB" ),
IF (
total < POWER ( 2, 30 ),
FORMAT ( total / POWER ( 2, 20 ), "#0.0# MB" ),
FORMAT ( total / POWER ( 2, 30 ), "#0.0# GB" )
)
)
)
Preparing for Power BI exam? Check out Power BI Syllabus now!