Dax Formula

[Anonymous]

 

Hello Team. I have been trying to do this for a while, i'd require anyone's expertise. I have two questions

1. I'm trying to get the formular to be able to get the difference between the sum of the ses values and  just one of those duplicates under the TS column. How do i do that pls. The trick is that i can have duplicate TS but the value of the TS duplicated into 9 places should be equals to the sum of the SES value. Now when they aren't equal, how do i get the formular to find the difference.

2. My second question would be formular on how to highlight when there's a large difference as red9that would require attendtion) and when there is a little or small difference as green.

[Greg_Deckler]

@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.