Add '$' Sign Only To Totaled Row In A Table

[srpeters]

Hello,

I was wondering if it is possible to add a '$' in front of my totaled rows' summarized values in a table without adding it to the tables' non-summarized values. I know I can add a conditional format to add sumbols to only the totaled row of a table, but the dollar sign is not one of the alloted symbols. Any Suggestions are appreciated.

Thank you in advance!

[fahadqadir3 · Accepted solution]

@srpeters you can put a $ sign on totals by using the following measure:

Measure dollar = IF(ISINSCOPE('Table'[ID]),[Measure 2030],FORMAT([Measure 2030],"#$0.00"))

Power BI file attached:

dollar sign.pbix

Regards,

Fahad Qadir

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Greg_Deckler · Accepted solution]

@srpeters What about this? PBIX attached.

Measure = 
    VAR __Sum = SUM('Table'[Column1])
    VAR __Result = IF( HASONEVALUE( 'Table'[Column2] ), __Sum, FORMAT( __Sum, "Currency" ) )
RETURN
    __Result

[fahadqadir3 · Accepted solution]

@srpeters you can put a $ sign on totals by using the following measure:

Measure dollar = IF(ISINSCOPE('Table'[ID]),[Measure 2030],FORMAT([Measure 2030],"#$0.00"))

Power BI file attached:

dollar sign.pbix

Regards,

Fahad Qadir

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!