Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
  • zenisekd's avatar
    zenisekd
    2 years ago

    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. 

  • Ahmedx's avatar
    Ahmedx
    2 years ago

    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

zenisekd's avatar
zenisekd
Super User
2 years ago

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.