Forum Discussion

H_insight's avatar
H_insight
Icon for Helper V rankHelper V
4 years ago
Solved

Count status by each region

Hi all,   I am trying to count the status by regions using the following measure, but no results are showing?   Measure = CALCULATE ( COUNTROWS ( CALCULATETABLE ( VALU...
Need Help
Need Help DAX
  • amitchandak's avatar
    amitchandak
    4 years ago

    H_insight , Try like

     

    calculate (
    distinctcount(TableP[Region]),
    FILTER (
    TableJ,
    TableJ[Status] = "Complete" && TableJ[Status] = "Pending")

    )

     

    or

     

    calculate (
    countrows(Summarize(TableP, TableP[Region],TableJ[Status])),
    FILTER (
    TableJ,
    TableJ[Status] = "Complete" && TableJ[Status] = "Pending")

    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

H_insight , Try like

 

calculate (
distinctcount(TableP[Region]),
FILTER (
TableJ,
TableJ[Status] = "Complete" && TableJ[Status] = "Pending")

)

 

or

 

calculate (
countrows(Summarize(TableP, TableP[Region],TableJ[Status])),
FILTER (
TableJ,
TableJ[Status] = "Complete" && TableJ[Status] = "Pending")

)