Forum Discussion

villa1980's avatar
villa1980
Resolver II
1 year ago
Solved

Depot count by group

Hi all,  I have a list of depots with their capacity. what I would like to do is create a measure to classify these Capcacity (ie, if >1 then ">100%", if >0.8  and <0.9 then "80-90%". Then once t...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    villa1980  , First Create a calculated column  

    Capacity_Measure_Groups =
    SWITCH (
    TRUE(),
    [Capacity_Used] > 1 , ">100%",
    [Capacity_Used] >= 0.9 , "90-100%",
    [Capacity_Used] >= 0.8 , "80-90%",
    [Capacity_Used] >= 0.7 , "70-80%",
    [Capacity_Used] >= 0.6 , "60-70%",
    [Capacity_Used] >= 0.5 , "50-60%",
    "<50%"
    )

     

    Then create a measure for count

    Depot_Capacity_Count =
    COUNTROWS (
    VALUES ( HOO_AOM[Depot Name] )
    )

     

     

     

    In your table visual, use the Capacity_Measure_Groups column and the Depot_Capacity_Count measure. This way, the groups will be correctly displayed along with their counts, even when the depots are not shown in the table.

     

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

villa1980  , First Create a calculated column  

Capacity_Measure_Groups =
SWITCH (
TRUE(),
[Capacity_Used] > 1 , ">100%",
[Capacity_Used] >= 0.9 , "90-100%",
[Capacity_Used] >= 0.8 , "80-90%",
[Capacity_Used] >= 0.7 , "70-80%",
[Capacity_Used] >= 0.6 , "60-70%",
[Capacity_Used] >= 0.5 , "50-60%",
"<50%"
)

 

Then create a measure for count

Depot_Capacity_Count =
COUNTROWS (
VALUES ( HOO_AOM[Depot Name] )
)

 

 

 

In your table visual, use the Capacity_Measure_Groups column and the Depot_Capacity_Count measure. This way, the groups will be correctly displayed along with their counts, even when the depots are not shown in the table.