Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
john121
Frequent Visitor

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 of country .

Note :count is being done based on country colum ,so for above data count for india should be 2/2=1 and  germany 

should be 1.

Please help!

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_0-1663675533194.png

 

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

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_0-1663675533194.png

 

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

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.