Forum Discussion

JesperBT's avatar
JesperBT
Frequent Visitor
3 years ago
Solved

Divide / Calculate / Countrows with filters

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!

 

/B

 

  • 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 
                )
            )
         )

2 Replies

  • 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 
                )
            )
         )
    • JesperBT's avatar
      JesperBT
      Frequent Visitor

      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,

      B