Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

new measure

Hello Everyone,   I was recently introduced to DAX and creating "New Measures" and I am in need of some help.  I want to create a new measure that combines and counts the number of 2 unique values ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous,

     

    You can try to use below formula:

    formula =
COUNTROWS (
    FILTER (
        ALL ( WSMTotal ),
        [Call Reason] IN {"No Repair Information","Repair Information Not Availab"}
    )
)

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for replying jthomson!  I am getting an error when applying the function you provided.

 

CALCULATE(COUNTROWS([WSM Total],[Call Reason]="No Repair Information" || "Repair Information Not Availab"))

 

The error msg I get is - "Too many arguments were passed to the COUNTROWS function.  The maximum aregument count for the function is 1."

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

You can try to use below formula:

formula =
COUNTROWS (
    FILTER (
        ALL ( WSMTotal ),
        [Call Reason] IN {"No Repair Information","Repair Information Not Availab"}
    )
)

Regards,
Xiaoxin Sheng