Forum Discussion
Chandrashekar
Resolver III
Resolver IIITretas : Not getting count based on variable
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 CompanyRegi...
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.
AlexisOlson
Super User
Super UserThe 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] )
)
ChandrashekarResolver III
Resolver IIIHello 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
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.