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

amitchandak 

 

Uhm, I think I still don't have permission to upload pbix file here:

 

Please see sample data:

 

Table1:

 

 

Table2:

 

 

 

 

 

 

Thanks for your help