Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I have a measure in which it returns the sum of revenue where the sale count is not 0 and not blank and tried the following code but I don't think its working. Can somebody help me with that?
Measure = SUM([Revenue])
,AND( [Sales Count] <> 0, ISBLANK([Sales Count]) <> FALSE )
Thanks!
Solved! Go to Solution.
Hi,
try something like this:
Hi @DOLEARY85 ,
thanks for the code correction and NOT() was the keyword I was looking for hence I'm marking that as solution!
Although even the corrected code was not working and was giving me the "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed." error. So I had to put all the condition inside the filter function (thanks to @amitchandak for the filter hint on one of his replies in the community).
FILTER(not(isblank('Table'[Sales Count])),'Table'[Sales Count]<>0))
Thanks again!
Can you see any error when creating this measure? Seems the parenthesis and the order of the arguments is not correct. You should use something like this:
Measure =
IF (
[Sales Count] <> 0 && NOT(ISBLANK([Sales Count])),
SUM([Revenue])
)
Hi,
try something like this:
Hi @DOLEARY85 ,
thanks for the code correction and NOT() was the keyword I was looking for hence I'm marking that as solution!
Although even the corrected code was not working and was giving me the "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed." error. So I had to put all the condition inside the filter function (thanks to @amitchandak for the filter hint on one of his replies in the community).
FILTER(not(isblank('Table'[Sales Count])),'Table'[Sales Count]<>0))
Thanks again!
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |