Forum Discussion

john121's avatar
john121
Frequent Visitor
4 years ago
Solved

If and Count condition together

I have data of country and Employee id. Country Emp_ID India        120 Germany   80 India         125   I want a condition that If country is india then divide the count of india /2 else count...
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirement.

     

     

    Expected result measure: = 
SUMX (
    DISTINCT ( Data[Country] ),
    CALCULATE (
        IF (
            SELECTEDVALUE ( Data[Country] ) = "India",
            COUNTROWS ( Data ) / 2,
            COUNTROWS ( Data )
        )
    )
)

     

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

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirement.

 

 

Expected result measure: = 
SUMX (
    DISTINCT ( Data[Country] ),
    CALCULATE (
        IF (
            SELECTEDVALUE ( Data[Country] ) = "India",
            COUNTROWS ( Data ) / 2,
            COUNTROWS ( Data )
        )
    )
)