Tretas : Not getting count based on variable

[Chandrashekar]

Hello Team,

am trying to get count of priority am using below code but it is not working.

Inflow_Priority =

var CompanyRegionAU_Company =

Max(CompanyRegionAU[Company])

Var CompanyRegionAU_Region=

Max(CompanyRegionAU[Region])

Var queueselect_queue=

Max(Queue[Queue])

Var Table_join=

CROSSJOIN(

SELECTCOLUMNS({CompanyRegionAU_Company},"Name",[Value]),

SELECTCOLUMNS({CompanyRegionAU_Region},"Region",[Value]),

SELECTCOLUMNS({queueselect_queue},"Queue",[Value])

)

RETURN

CALCULATE(

COUNTROWS(Source),FILTER(all(Source),Source[Priority_is]=1),

TREATAS(Table_join,Source[company],Source[Region],Source[Queue])

)

Regards,

Chandrashekar B

[AlexisOlson]

The cross join construction feels odd to me.

I think I'd try writing this DAX more like this:

Inflow_Priority =
CALCULATE (
    COUNTROWS ( Source ),
    FILTER ( ALL ( Source ), Source[Priority_is] = 1 ),
    TREATAS (
        SUMMARIZE ( CompanyRegionAU, CompanyRegionAU[Company], CompanyRegionAU[Region] ),
        Source[company], Source[Region]
    ),
    TREATAS ( VALUES ( Queue[Queue] ), Source[Queue] )
)

[Chandrashekar]

Hello Alex,

I tried your solution but it is not working. I need Priority 1 and Priority 2 in different columns.

Regards,

Chandrashekar B

[Chandrashekar]

Hello Alex,

Sorry it is my mistake(Format issue it was text and turned to Number) and it is working now.

[AlexisOlson · Accepted solution]

Great!

Please accept the solution(s) that resolved your question in order to mark it as accepted so future readers can find it more quickly.

[Chandrashekar]

Hello Team,

Please see attached example report Sample Report as am trying to get priority count am using below code but it is not working.

[smpa01]

@Chandrashekar  I am guessing you are expecting this

To reach the following outcome, you need two measures

_countrows =
VAR _name =
    MAX ( Table3[Name] )
VAR _location =
    MAX ( Table3[Location] )
VAR _tbl =
    CROSSJOIN (
        SELECTCOLUMNS ( { _name }, "name", [Value] ),
        SELECTCOLUMNS ( { _location }, "location", [Value] )
    )
RETURN
    CALCULATE (
        COUNTROWS ( FILTER ( Table1, Table1[Priority] = 1 ) ),
        TREATAS ( _tbl, Table1[Name], Table1[Location] )
    )



Sum = SUMX(Table3,[_countrows])

[Chandrashekar]

Hello,

I need to Priority1 and Pririty 2 in two different columns.

Regards,

Chandrashekar B

[DimaMD]

Hi, Is this your desired result?

[Chandrashekar]

Hello,

I need to Priority1 and Pririty 2 in two different columns.

Regards,

Chandrashekar B