Forum Discussion

gladies123's avatar
gladies123
Helper I
4 years ago
Solved

Reg: hide a value

Hi, Kindly help me to hide a value(1) which is highlighted i have created si.no using following dax(measure) si.no= RANKX(ALLSELECTED(cxsurrender[V_RET_RESULT]),CALCULATE(SUM(cxsurrender[Index])),...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Check whether you use right field in HASONEVALUE function. It should work.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi gladies123 ,

 

Let's take an example:

Measure = IF(ISINSCOPE('Table'[Column1]),1,BLANK())

 

So you measure may be:

Measure = IF(ISINSCOPE('Table'[the ROW field in matrix]),[your rank measure],BLANK())

 

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.