Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have this visual that shows how efficiently each of our machines are running. There's a legend that gives a color to each machine and in total if they reach 100% that means all machines were running at 100% capacity for that 30-minute time period. The measure basically does
DIVIDE(efficiency, CALCULATE(DISTINCTCOUNT('MachineData'[Machine]), all(MachineData)))
so it calculates the efficiency and divides it by the total number of machines (ignoring the filter that the legend puts on it). Unfortunately, it looks wonky if you filter it by machine then
Solved! Go to Solution.
If you want to keep the first screenshot as it is, have a look at SELECTEDVALUE or HASONEVALUE. Basically, if only one machine is selected, use a different dax without the all.
Maybe try using ALLEXCEPT instead of ALL to keep the machine filtering?
Last option maybe replace your ALL(MachineData) with ALL(MachineData[Machine]) with no other changes.
If you want to keep the first screenshot as it is, have a look at SELECTEDVALUE or HASONEVALUE. Basically, if only one machine is selected, use a different dax without the all.
Maybe try using ALLEXCEPT instead of ALL to keep the machine filtering?
Last option maybe replace your ALL(MachineData) with ALL(MachineData[Machine]) with no other changes.
Thank you for the help. I'll look into SELECTEDVALUE/HASONEVALUE. I'm confused about your last suggestion, it calculates the % efficiency for the machine which is good, and then divides it by the distinct count of all machines which is bad because the slicer doesnt affect it
So the legend causes the measure to only have one machine in its table, and I dont know how to have it detect how many machines are selected in the slicer.
It seems the last option would return all 6 machines still, even if I selected 3 in the slicer, am I misunderstanding?
You are correct.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
215 | |
89 | |
76 | |
66 | |
60 |