none
Find count DAX Range RRS feed

  • Question

  • Table 1:         "         Table 2

    Col 1:ID         "         Col 1: Range   Col 2: Count ??

    2                    "        <10  

    12                  "        10-20

    15                  "         21-30

    23

    I want count of ID (Col 2 in Table 2) falling between the ranges in Col2 of Table 2.

    Kindly help me to write DAX expression.

    I have tried with IF, Calculate and countX functions.

    Thanks in advance!

    Monday, July 1, 2019 9:20 AM

Answers

All replies