Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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....
Solved! Go to 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 , 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.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
106 | |
87 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |