Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I'm new to the PowerBi.
I have a device usage table (TableA) with all the devices and monthly usage data.
How can I calculate the number of devices (count) that were no use?
e.g 2020-01 only, there were two devices (B and C) has no hour use.
if both 2020-01 and 2020-02 are selected, then only one device (B) has no hour use.
Device | Month | Use Hours |
A | 2020-01 | 1 |
A | 2020-02 | 2 |
B | 2020-01 | 0 |
B | 2020-02 | 0 |
C | 2020-01 | 0 |
C | 2020-02 | 1 |
D | 2020-01 | 1 |
D | 2020-02 | 0 |
I was trying to use Calculate, but PowerBI doesn't allow the caculate function with a measure in the filter section?
measure_total_use = sum(TableA[Use Hours])
measure_zero_Use_Count = Caculate(distinctcount(TableA[Device], [measure_total_use]=0))
How to the get the count of no-use device from the table A above?
I appreciate any help!
Elac
Solved! Go to Solution.
you can try this
Measure 2 = CALCULATE(DISTINCTCOUNT('Table'[device]),FILTER(VALUES('Table'[device]) ,[Measure]=0))
Proud to be a Super User!
wow! That works. The values function is wonderful here!
Thank you so much!
you are welcome
Proud to be a Super User!
you can try this
Measure 2 = CALCULATE(DISTINCTCOUNT('Table'[device]),FILTER(VALUES('Table'[device]) ,[Measure]=0))
Proud to be a Super User!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |