March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Dear Friends,
I need help with DAX measure.
I have two list here. master list and the list from data entry people.
I have a master list contains country and items related to the each country. This is stable and maybe updated later according to the requirement. Sample list as below.
Country | Item | Item ID |
USA | CHAIR | 1 |
AUSTRALIA | TABLE | 2 |
INDIA | WHITE BOARD | 3 |
BRAZIL | CURTAIN | 4 |
CHINA | INSTRUMENTS | 5 |
MALAYSIA | UTENSILS | 6 |
USA | CHAIR | 7 |
AUSTRALIA | TABLE | 8 |
INDIA | WHITE BOARD | 9 |
BRAZIL | CURTAIN | 10 |
CHINA | INSTRUMENTS | 11 |
MALAYSIA | UTENSILS | 12 |
USA | CHAIR | 13 |
AUSTRALIA | TABLE | 14 |
INDIA | WHITE BOARD | 15 |
BRAZIL | CURTAIN | 16 |
CHINA | INSTRUMENTS | 17 |
MALAYSIA | UTENSILS | 18 |
USA | CHAIR | 19 |
AUSTRALIA | TABLE | 20 |
INDIA | WHITE BOARD | 21 |
BRAZIL | CURTAIN | 22 |
CHINA | INSTRUMENTS | 23 |
MALAYSIA | UTENSILS | 24 |
USA | CHAIR | 25 |
AUSTRALIA | TABLE | 26 |
INDIA | WHITE BOARD | 27 |
BRAZIL | CURTAIN | 28 |
CHINA | INSTRUMENTS | 29 |
MALAYSIA | UTENSILS | 30 |
So our data entry people enter the data as thy receive into the system which looks like below.
Country | Item | Item ID |
USA | CHAIR | 1 |
AUSTRALIA | TABLE | 2 |
INDIA | WHITE BOARD | 3 |
BRAZIL | CURTAIN | 4 |
CHINA | INSTRUMENTS | 5 |
MALAYSIA | UTENSILS | 6 |
USA | CHAIR | 7 |
AUSTRALIA | TABLE | 8 |
INDIA | WHITE BOARD | 9 |
BRAZIL | CURTAIN | 10 |
CHINA | INSTRUMENTS | 11 |
MALAYSIA | UTENSILS | 12 |
USA | CHAIR | 13 |
AUSTRALIA | TABLE | 14 |
So I need to find out the total percentage of data entered into the system by country vise compared to the master list.
I'm new to the Power BI with little knowledge. So I need some help.
Thank You in advance.
Solved! Go to Solution.
Hi @EbyEaso
Try this measure in a card visual:
Measure =
DIVIDE ( COUNTROWS ( INTERSECT ( Table1, Table2 ) ), COUNTROWS ( Table1 ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Wow!
This is awesome. Thank You @AlB , @Anonymous . Appreciate you both.
Alos I have a question just came up in mind regardin the same table. What if my master list is in different table by country wise. In the previous senario all countries are in in same master list. Now i have master list for each country.
Without appending it is ther a measure to find the same calculation in thise senario?
Just my thaught if I had to face that.
Not really. You could do a UNION( ) of all the tables within the measure and work on that as we did in the code shown earlier. I'm not sure that would be of much help. It's probably best to do the merge of all those tables in Power Query, unless you want to keep them separately
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @EbyEaso
Try this measure in a card visual:
Measure =
DIVIDE ( COUNTROWS ( INTERSECT ( Table1, Table2 ) ), COUNTROWS ( Table1 ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
23 | |
15 | |
12 | |
9 | |
8 |
User | Count |
---|---|
41 | |
32 | |
29 | |
12 | |
12 |