Forum Discussion

carlol's avatar
carlol
Resolver I
3 years ago
Solved

redact Aggregated Column value

Hi    Is it possible to redact QTY column ,   if Value is 5 or less it illustrated <5 But when aggregated it will still correclty sum the total , 2+ 10 = 12 . illustrated in powerbi visual is <5 &...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi， carlol 

    It's difficult to redact QTY column.

    You may need to add new fields like this:

    calculated column:

    New Qty = IF('Table'[Qty]<5,"<5",FORMAT('Table'[Qty],"general number"))

    measure:

    Result = 
 var tab=VALUES('Table'[New Qty])
 return CONCATENATEX(tab,'Table'[New Qty],"&")

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi， carlol 

It's difficult to redact QTY column.

You may need to add new fields like this:

calculated column:

New Qty = IF('Table'[Qty]<5,"<5",FORMAT('Table'[Qty],"general number"))

measure:

Result = 
 var tab=VALUES('Table'[New Qty])
 return CONCATENATEX(tab,'Table'[New Qty],"&")

Best Regards,
Community Support Team _ Eason