Forum Discussion

ambillate's avatar
ambillate
Frequent Visitor
5 years ago
Solved

Measure

Hi Guys,   Humbly asking for your help.   My current Matrix is like this:   Using this measure: Section = SWITCH(SELECTEDVALUE(Level[Level#]), 1,[Percentage], 2, 0, 3, 0,1)   As exp...
  • amitchandak's avatar
    amitchandak
    5 years ago

    ambillate , Try a measure like one of the two

     

    Section =
    var _1 = SWITCH(SELECTEDVALUE(Level[Level#]),
    1,[Percentage],
    2, 0,
    3, 0,1)
    return if(isblank(_1),1,_1)


    Section =
    var _1 = SWITCH(SELECTEDVALUE(Level[Level#]),
    1,[Percentage],
    2, 0,
    3, 0,1)
    return if(isblank(_1),if(max(Table[Lavel]) = 1,1,0),_1)

ambillate's avatar
ambillate
Frequent Visitor
5 years ago

Hi amitchandak,

 

I tried the two measures, but it gives me this result.

 

In Level 2 & 3 (column C), it's still 100%.

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    ambillate ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.