Forum Discussion

stevensun's avatar
stevensun
New Member
4 years ago

Formatting Numbers for the Total Row / First Row only

Hi everyone, I am working on finalizing a Power BI report and got stuck on some currency formatting issues.   I have some measures in place and built some matrix and tables, those measures are for...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi stevensun ,

 

I tried my best to achieve the effect you want to achieve. Both results are in text format, which requires attention.

Create two measures.

 

Measure = IF(ISINSCOPE('Table'[Category]),SUM('Table'[Value]),"$ "&SUM('Table'[Value]))
Measure 2 = IF(MAX('Table'[Category])="Category 2","$ "&SUM('Table'[Value]),SUM('Table'[Value]))

 

 

Reference: ISINSCOPE function (DAX) - DAX | Microsoft Docs

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.