Закрыт

PowerBI - DAX Syntax- 1 Query

I'm new to DAX and looking to write a very simple query to calculate Distinctcount of ids if a condition is met.

In the attached excel, there are two columns Orders and Inflammable. Each order can have multiple rows (based on SKUs) and Inflammable is Y/N field to tell whether SKU is inflammable. My ask is to find the number of distinct orders where there are more than two inflammable SKUs.

Please see the attached excel file to know more about it.

A skilled person may not even take 5 min to write/correct the measure.

Навыки: Excel, Visual Basic, Обработка данных, Архитектура ПО, Ввод данных

О клиенте:
( 0 отзыв(-а, -ов) ) 285/23, Onkar Nagar, Tri Nagar, India

ID проекта: #34723826

11 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹982

nikhilgupta84

Data Scientist/Analytics Consultant with over 16 years of industry experience. I have worked in various domains like Retail, Banking, Insurance and Healthcare (Real World evidence). I have been invoved into end-to-end Больше

₹1500 INR за 1 день
(3 отзывов(-а))
3.1
(4 отзывов(-а))
3.0
janeinereane

I am an Accounting major with great experience in Accounting Software such as Netsuites and Quickbooks. I have excellent skills in Microsoft Excel that can make a qualified for this project. You can contact me if you'r Больше

₹600 INR за 4 дней(-я)
(0 отзывов(-а))
0.0
nlchhapola7

Main yah kam kar sakta hun iske liye Mujhe okay Ham kar sakte hain bahan ke land madrachod Teri bahan ka bhosda

₹800 INR за 5 дней(-я)
(0 отзывов(-а))
0.0
sfaiq030

I will not say that I'm best at the work but i have work experience for 1 year of data entry, excel. I can manage the data account with a proper way. I have excellent skills in Microsoft Excel that can make a qualified Больше

₹600 INR за 5 дней(-я)
(0 отзывов(-а))
0.0
sajivinin

I'm Data engineer Major with great experience in Power BI and Tableau . I have excellent skills in Microsoft Excel that can make a qualified for this project. You can contact me if you're interested.

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
thundrous

Greetings. That's an easy DAX expression. I've already done. I have 5 years+ experience in Microsoft Power BI. Hope this proposal helps you.

₹1000 INR за 1 день
(0 отзывов(-а))
0.0
chvrammohan

13years of real time industry experience. Also committed resource towards the client. Will help you even after the project completion.

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
taranalytics

Hi I have experience in writing complex DAX measures, and building Excel models & Power BI dashboards from scratch, and also making changes to the existing reports. I am quick at understanding the business context a Больше

₹1200 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
Vindhya0912

I'm Software engineer Major with great experience in Power BI and Tableau . I have excellent skills in Microsoft Excel that can make a qualified for this project. You can contact me if you're interested.

₹1000 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
anushatvenu

I am a software professional with 8 years of industry experience across various programming and data analytics tools. I have created various story boards for corporate giants in my career, so, I believe I can help you Больше

₹950 INR за 7 дней(-я)
(0 отзывов(-а))
0.0