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])),,DESC,Dense) that's why 1 is displaying please help me to hide that 1.
thanks,
gladis

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    gladies123 Try this:

    si.no= IF(HASONEVALUE(cxsurrender[your_crossed_out_field]),RANKX(ALLSELECTED(cxsurrender[V_RET_RESULT]),CALCULATE(SUM(cxsurrender[Index])),,DESC,Dense),BLANK())

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Right, for total it returns blank. What should it return?

  • 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.