Forum Discussion

MAP's avatar
MAP
Frequent Visitor
2 years ago
Solved

Zero counts

I have stock exchange data in power bi.i have a measure that calculates whether closing price is maximum or not.if closing price is maximum this measure gives to the answer equall to zero.Now I want ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    You could do this using SUMX and VALUES.  First you'll need to understand what groupings will let you check a zero for.  Maybe its a particular stockcode.  Here is an example:

    Zero Count = SUMX(
    VALUES('Stocks'[Stock Code]),
    IF([Closing price max check] = 0, 1, 0)
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

You could do this using SUMX and VALUES.  First you'll need to understand what groupings will let you check a zero for.  Maybe its a particular stockcode.  Here is an example:

Zero Count = SUMX(
    VALUES('Stocks'[Stock Code]),
    IF([Closing price max check] = 0, 1, 0)
)