The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello Everyone,
I am a very new user to Power Bi, so I will try to explain this best I can. I have a set of data tracking Log times for devices, and I am trying to find the percentage of all devices being used 3 or more times a day. I have a measure currently tracking how many times each device is being used daily and a measure tracking the total number of devices, but I can not figure out how to create a measure to see what percentage of those devices are being used 3 or more times per day.
Like I said I am a very new user to Power Bi and any help is greatly appreciated.
Thank you in advance,
Alex
Hey,
Try something like this:
Measure = DIVIDE(IF([InsuredMeasure] = <4; SUM([othermeasure]);"");SUM([othermeasure]))
I typed this from my mind since i don't have any data.
Try to mess around with it, and see if it helps you out.
Good luck !
I tried that but I can't seem to get it to work, but I have created a measure to return a true if the device is used 3 times or more and false if not but I am unable to figure out how to get the percentage of the total that is true.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
92 | |
90 | |
72 | |
69 |
User | Count |
---|---|
231 | |
127 | |
117 | |
82 | |
82 |