Forum Discussion
Apply SUM Total to a Conditionally Formatted Column
- Test Sum =var s = SUMX(ADDCOLUMNS('Table',"s",if([APType]="Classic",0,VALUE([TEST]))),[s])RETURN if(s=0,"N/A",FORMAT(s,"#"))
the screenshots are too small.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi lbendlin - Thank you for the note, I did not notice that the images were too small when I was creating it. Apologies for that.
I've tried adding a table of what I mean but since I'm dealing with a Matrix the screenshots felt like it was the best way to explain while adding the queries in it.
I refrained from uploading the pbix file or any other queries, since the point is to avoid sensitive data as you advised.
Please let me know if this helps or if there's some other way I could help provide more information.
You cannot mix text and numbers in your output unless you format your numbers as text too.
Thank you lbendlin,
And in that case if the numbers were text too then the SUM wouldn't be possible anyways since it's of text format right?
Appreciate the clarification/confirmation on this.
you can still do your math to arrive at the totals but the output format of that math needs to be text.