Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Could you please help me with the measure calculation for the below scenario,
I have a table like shown below which has the 'Name' and the number of times each person has visited a country:
Number of visits | ||||
Name | China | US | UK | Germany |
Roy | 3 | 0 | 0 | 0 |
Joe | 2 | 0 | 3 | 0 |
Marie | 1 | 5 | 0 | 1 |
Vish | 0 | 1 | 1 | 1 |
Wayne | 5 | 0 | 0 | 0 |
I need to find the number of people who only visited China and not other countries.
In this case, it has to be '2' because only Roy and Wayne have visited China but not other countries.
Any help on this is appreciated.
Thanks a lot.
Its actually an output from a excel pivot that was shared in a normal excel which i am using as a source.
@Anonymous_mdky
You may keep it pivotted if you have samll number of columns which I doubt with your real data. In case of large number of columns it is advised to unpivote the table using power query. That would also keep the door open for dynamic solution without having to add a new disconnected table. Three possible solutions as follows:
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |