Matrix report trend value

[Anonymous]

 I have a matrix report which has following values. But , need to show trend as seperate ICON at the top of the Matrix report.

Trend should be Postive ,if All  are Zeros in the difference value

Trend should be Negative ,if any of the difference value having variation.

Can someone help me DAX how to achive trend value.

Example: The below scenerio ,Trend value is Negative since states 2,6 are having variation in the difference value.

                                                 TREND - NEGATIVE

   

[amitchandak · Accepted solution]

@Anonymous , Try like

if(
countx(filter(summarize(Table, Table[state], "_1", sumx(Table, if(Table[source]-Table[Target]<0,1,0))),[_1]>0),[state]) >0, "Negative","Positive")

[amitchandak · Accepted solution]

@Anonymous , Data is grouped at the state level first and then filtered and then aggregated gain

[amitchandak · Accepted solution]

@Anonymous , Try like

if(
countx(filter(summarize(Table, Table[state], "_1", sumx(Table, if(Table[source]-Table[Target]<0,1,0))),[_1]>0),[state]) >0, "Negative","Positive")

[Anonymous]

Thank,Amit. Its working somehow. But need to do through testing for my entire report. Can you please explain me this syantax what is happening here?

[amitchandak · Accepted solution]

@Anonymous , Data is grouped at the state level first and then filtered and then aggregated gain

[Anonymous · Accepted solution]

Thanks a lot. Its working perfect after making the changes as per my requriment.