Forum Discussion
matrix
I Dont want to show data that dosent have any values.. when selected any of the above element from any matrix.
Eg. i have selected ws non feeder from channel and i only want data that is of ws non feeder and not the blank data.
"the mapping is correctly done".
Ahmedx
Anonymous
Hi, two options: 1) you will correct the measure %Total Sales, which gives a value to every line, which is the reason all lines are displayed or 2) you use a filter on every visual (in the left panel) and set that for a certain column, e.g. sales the value must not be blank, or greater than zero.If I understood you correctly, then you need to rewrite all the measures for example
if you have such a measure :m1 = SUM('table'[Value])
then you should rewrite it like this
m1 =
VAR _t1= SUM('table'[Value])
RETURN
IF(_t1,_t1)this applies to all measures that are in the matrix
2 Replies
Anonymous
Hi, two options: 1) you will correct the measure %Total Sales, which gives a value to every line, which is the reason all lines are displayed or 2) you use a filter on every visual (in the left panel) and set that for a certain column, e.g. sales the value must not be blank, or greater than zero.If I understood you correctly, then you need to rewrite all the measures for example
if you have such a measure :m1 = SUM('table'[Value])
then you should rewrite it like this
m1 =
VAR _t1= SUM('table'[Value])
RETURN
IF(_t1,_t1)this applies to all measures that are in the matrix