Measure based off numbers

Anonymous — Thu, 04 Nov 2021 20:11:37 GMT

I have a column "sales" in dataset "data" and whether sale was made or not (1 = sales, 0 = no sales)

I am trying to create two measures for "sale" and "no sale"

I tried:
No sale = COUNTROWS(FILTER(data,data[sales] = "0")) but i get an error saying filter is not the correct syntax
this usually works based off text but im not sure how to do it by number

looking through power bi forum found another measure:

No sale = CALCULATE(SUM(data[sales]); FILTER(data; data[sales]=0)))
but get same error for wrong syntax for filter

what would be the correct syntax for this or is my entore measure off for what I am trying to do?

Re: Measure based off numbers

smpa01 — Thu, 04 Nov 2021 20:22:03 GMT

Anonymous this should work (whatever you are doing) without any issue.

Take a look here and post the pbix/sample data here for debugging

Re: Measure based off numbers

Anonymous — Thu, 04 Nov 2021 20:40:34 GMT

Thank you!! Worked beautifully

topic Re: Measure based off numbers in DAX Commands and Tips

Measure based off numbers

Re: Measure based off numbers

Re: Measure based off numbers