Can't use measure as categoric

[adriancho_BI]

Hello! Please your help!! I'm trying to categorize a measure and then use it as columns in a Stacked Column Chart (X axis):
Measure 1: Count the phone_numbers by device_id in other table

FORMAT(CALCULATE(

    DISTINCTCOUNT(data_device[phone_number]),

    ALLEXCEPT(browsing_data_device, browsing_data_device[device_id])

),"#")

Measure 2: Here I'm trying to create a category but can't use it as I mention above

Phones By Device (Group) =

SWITCH (

    TRUE (),

    [Browsing Phones By Device] = 0, "0",

    [Browsing Phones By Device] = 1, "1",

    [Browsing Phones By Device] = 2, "2",

    [Browsing Phones By Device] >= 3, ">=3"

    )

Thanks in advance for the help : )

[Idrissshatila · Accepted solution]

Hello @adriancho_BI ,

''in order to be able to use it as a column, it should be a calculated column, it won't work as a measure.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[v-xinruzhu-msft · Accepted solution]

Hi @adriancho_BI 

The information @Idrissshatila offered is right, you cannot put the measure to x-axis, based on the infotmation @Idrissshatila  offered, I will offer some more information for you to refer.

You can consider to create a table called type.

Then put the type to the x-axis, then  use this type column in conjunction with Phones By Device (Group). 

e.g You can to calculate the count of table.

Measure =
CALCULATE (
    COUNTROWS ( data_device ),
    FILTER ( data_device, [Phones By Device(Group)] IN VALUES ( 'Type'[Type] ) )
)

Put the measure to the value.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila · Accepted solution]

Hello @adriancho_BI ,

''in order to be able to use it as a column, it should be a calculated column, it won't work as a measure.