Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I would like to identify number of weeks with positive percentage for KPI on material level.
Base on time period selected I would be able to identify how many time KPI was in positive numbers.
Please keep in mind my data are base on week dates.
Thank you. And don't hesitate if you want more clear picture of what I want to achieve.
Solved! Go to Solution.
Hi, @Sefino535
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
All measures are in the sample pbix file with a step-number.
https://www.dropbox.com/s/f2kbxjmb6w7e7ci/sefino.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
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.
Hi, @Sefino535
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
All measures are in the sample pbix file with a step-number.
https://www.dropbox.com/s/f2kbxjmb6w7e7ci/sefino.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
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.
Thanks Kim,
Exactly what I was looking for!
Hi @Sefino535
Can you show the structure of the relevant table(s) with some data? And explain what you need with an example based on that data?
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |