Reg: hide a value

[gladies123]

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

[v-eqin-msft]

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.

[Anonymous]

@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())

[gladies123]

Thanks but it returned blank

[Anonymous]

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

[gladies123]

it returns whole column as blank, 1(value) in the total section has to hide

[Anonymous · Accepted solution]

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