Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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) ) |
User | Count |
---|---|
50 | |
39 | |
18 | |
14 | |
13 |
User | Count |
---|---|
99 | |
67 | |
28 | |
18 | |
13 |