Forum Discussion
Matrix report trend value
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 ...
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 , Data is grouped at the state level first and then filtered and then aggregated gain
Thanks a lot. Its working perfect after making the changes as per my requriment.
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")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?
Anonymous , Data is grouped at the state level first and then filtered and then aggregated gain
Thanks a lot. Its working perfect after making the changes as per my requriment.