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
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
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
4 Replies
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