topic Divide / Calculate / Countrows with filters in DAX Commands and Tips

Divide / Calculate / Countrows with filters

JesperBT — Fri, 24 Feb 2023 11:02:12 GMT

Hey Gurus,

I'm looking for help creating a measure that can calculate a percentage.

I have tried multiple way's of getting this to work and I'm also willing to split them into different measures if that is the only way to do it.

TotalLSC = CALCULATE ( DIVIDE ( COUNTROWS ( FILTER ( 'data cfb', 'data cfb'[COM_DeliveryPMA] = 1 && LEFT('data cfb'[Node Code], 3) = "LSC" )), COUNTROWS ( FILTER ( 'data cfb', 'data cfb'[COM_DeliveryPMA] = 1 ) )))

I want to divide total rows where DeliveryPMA = 1 and Node Code starts with LSC divided by the total rows where DeliveryPMA = 1.

Thanks in advance, I really appreciate your help!

Re: Divide / Calculate / Countrows with filters

FreemanZ — Fri, 24 Feb 2023 11:14:37 GMT

hi JesperBT

the issue might come from some unmentioned context, try like:

TotalLSC =

DIVIDE (

COUNTROWS (

FILTER (

ALL('data cfb'),

'data cfb'[COM_DeliveryPMA] = 1

&& LEFT('data cfb'[Node Code], 3) = "LSC"

)

COUNTROWS (

FILTER (

ALL('data cfb'),

'data cfb'[COM_DeliveryPMA] = 1

)

Re: Divide / Calculate / Countrows with filters

JesperBT — Fri, 24 Feb 2023 12:15:42 GMT

Hi FreemanZ,

I don't know what the reason was, but it seems to work now.

Thanks a lot for taking the time to help me!

Best regards,