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 to count those zero in a separate measures

  • RossEdwards's avatar
    RossEdwards
    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)
)

2 Replies

  • RossEdwards's avatar
    RossEdwards
    Solution Sage
    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)
)