can we show text value like "N/A" in the calculated %column

[Raj007]

Hi All,

Thank you so much for your time. I have this scenario where i calculate the %value with the numerator which is a measure and the denominator which is another measure ...something like below
KRI%= 100 - (KRI_SUM/ALL_BAND1) * 100
1).KRI_SUM - This is the numerator which is a calculated measure
2).ALL_BAND1 - This is the denominator which is a calculated measure
I have a field in my dataset like BandType which has 1,2,3,4 (just 4 values in it)
my % values should get calculated only for the BandType=1 (when I select 2,3,4 in the slicer the %value shoud show "N/A")
can we show N/A - i tried to but i still seee the BLANK in 
any suggestiions for the best approach....

[amitchandak]

@Raj007 , Can share what you have done. This need a column and column as of now can not take slicer value. So I doubt that.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Raj007]

Hi Amit, thanks for checking
I use the slicer to select BandType which has 1 2 3 4 values - Measure is KPI% which is shown in gauge dial
say the scenario is to show the %value in gauge dial for the BandType=1 when BandType is 2,3,4 then dont calculate and show N/A

[v-jayw-msft · Accepted solution]

Hi @Raj007 ,

Create a independent slicer table and then create a measure as below.

measure = IF(SELECTEDVALUE('slicer'[type]=1),[%value],"N/A")

Best Regards,

Jay

[Raj007]

Thank you Jay - I had to just use it in variable like
Testing=
VAR Test=calculation
return 
if(isblank(Test),"N/A",Test)

This does not work in Gauge it is still showing "Blank" - it shows N/A in card but not in guage