Forum Discussion

Fab117's avatar
Fab117
Icon for Helper IV rankHelper IV
4 years ago
Solved

Measure to count iteration of specific character string

Hello,   I'm newbie with Power BI. I'm quite familiar with VBA, but not at all with Dax => PowerQuery requests.   I started building my first Power BI report based on several data base fields, b...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Fab117 ,

     

    I'll first give you a popular science about the difference between M language and DAX language. In Power Query, we'll use M. DAX, which we use in Power BI Desktop.

    Here's the solution in Power BI Desktop, which means I used DAX to complete.

    Germany = CALCULATE(COUNT('Table'[AreaImpacted]),CONTAINSSTRING('Table'[AreaImpacted],"Germany"))
    Canada = CALCULATE(COUNT('Table'[AreaImpacted]),CONTAINSSTRING('Table'[AreaImpacted],"Canada"))
    USA = CALCULATE(COUNT('Table'[AreaImpacted]),CONTAINSSTRING('Table'[AreaImpacted],"USA"))
    France = CALCULATE(COUNT('Table'[AreaImpacted]),CONTAINSSTRING('Table'[AreaImpacted],"France"))

     

     

     

     

    Best Regards,

    Stephen Tao

     

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Fab117 ,

 

I'll first give you a popular science about the difference between M language and DAX language. In Power Query, we'll use M. DAX, which we use in Power BI Desktop.

Here's the solution in Power BI Desktop, which means I used DAX to complete.

Germany = CALCULATE(COUNT('Table'[AreaImpacted]),CONTAINSSTRING('Table'[AreaImpacted],"Germany"))
Canada = CALCULATE(COUNT('Table'[AreaImpacted]),CONTAINSSTRING('Table'[AreaImpacted],"Canada"))
USA = CALCULATE(COUNT('Table'[AreaImpacted]),CONTAINSSTRING('Table'[AreaImpacted],"USA"))
France = CALCULATE(COUNT('Table'[AreaImpacted]),CONTAINSSTRING('Table'[AreaImpacted],"France"))

 

 

 

 

Best Regards,

Stephen Tao

 

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

Fab117's avatar
Fab117
Icon for Helper IV rankHelper IV
4 years ago

Hi Anonymous ,

Thank you very much for taking time looking at my challenge and for this solution which fit perfectly my needs.

Have a nice week.

 

Fab