Forum Discussion
Memorable MemberTarget Vari % display total Black color.
Hi All
Target Vari % display total Black color.
May i know where i should check to make the % appear ?
Already check the condition setting also same.
Set to white black ground also display null.
Paul
It seems that you used a different measure:
Old:
Target Vari % = if(isblank( divide([Sales YTD]-[Target YTD],[Target YTD])),1, divide([Sales YTD]-[Target YTD],[Sales LYTD]))New:Target Vari % = if(isblank( divide([Sales YTD]-[Target YTD],[Target YTD])),1, divide([Sales YTD]-[Target YTD],[Sales YTD]))
6 Replies
- themistoklis
Community Champion
It seems that you used a different measure:
Old:
Target Vari % = if(isblank( divide([Sales YTD]-[Target YTD],[Target YTD])),1, divide([Sales YTD]-[Target YTD],[Sales LYTD]))New:Target Vari % = if(isblank( divide([Sales YTD]-[Target YTD],[Target YTD])),1, divide([Sales YTD]-[Target YTD],[Sales YTD]))
admin11Hi Themistokis
Wow you are very sharp. may i know how to find out ?
Paul
- themistoklis
Hello admin11 ,
I just checked the formula and it didnt seem corerct to me.
You were looking for % diff on YTD and you had a value for Last Year.
That's it actually
- PhilipTreacy
Super User
Hi admin11
Your measure Sales LYTD is returning a blank for those rows where you are getting a blank for Target Vari %
This is because you are calculating Target Vari % using the DIVIDE function and it returns blank when the denominator is blank.
Regards
Phil
- amitchandak
admin11 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- admin11
HiAll
Enclosed is my PBI sample file
