I had created a measure which was
So whenever the item qty is 0 or no value is value then ASP appears as 0. But the user does not want to see those systems which has no values at all.
If we put a visual filter not to show ASP as 0 then all the records where maybe other values such as sales, units are there for the system but asp is 0 then those records are also not shown.
Is there any other way to get this result.
Go to Solution.
Please try the below.
newmeasure =DIVIDE ( [Sales Amount], SUM ( Sales[Item Qty] ), blank())
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
View solution in original post
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.