Forum Discussion

u92690's avatar
u92690
Frequent Visitor
5 years ago

Measure with multiple slicers applying (Beginner level) - example posted

Hey Friends,   I have a quiet simple issue, I guess, but im not getting to sort it out. I have two tabels, one with the cases and the other one with the tests, all of them broken down by administra...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi u92690 ,

 

Sorry for that the information you have provided is not making the problem clear to me.

Could you please tell me the expected output via some screenshots?

By the way, I have created a new table in case you want to split the level type:

Table = 
    var _1=DISTINCT( SELECTCOLUMNS('Territories',"Type",LEFT([Region - Level 1],2),"Level",RIGHT([Region - Level 1],1)))
    var _2=DISTINCT( SELECTCOLUMNS('Territories',"Type",LEFT([Region - Level 2],2),"Level",RIGHT([Region - Level 2],1)))
    var _3=DISTINCT( SELECTCOLUMNS('Territories',"Type",LEFT([Region - Level 3],2),"Level",RIGHT([Region - Level 3],1)))
return DISTINCT(UNION(_1,_2,_3))

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.