topic Re: Measure DAX Formula - to calculate number of instances a word appear in another column in DAX Commands and Tips

Measure DAX Formula - to calculate number of instances a word appear in another column

Anonymous — Tue, 21 Jun 2022 03:12:18 GMT

I am looking to find a formula, to calculate a measure.

Scenario

I have 2 columns - "Licensee" and "Advisers"
Multiple Advisers can belong to the same licensee

Ask

how to calculate a measure to That I can use in "Card" visual, to show case number of Licensee with more than 20 advisers only.

Re: Measure DAX Formula - to calculate number of instances a word appear in another column

tamerj1 — Tue, 21 Jun 2022 03:23:31 GMT

Hi Anonymous

a small sample data would be greatly useful to support with accurate code.

Re: Measure DAX Formula - to calculate number of instances a word appear in another column

Jihwan_Kim — Tue, 21 Jun 2022 03:25:39 GMT

Hi,

I am not sure without seeing your data model, however, I tried to create a sample pbix file like below.

Please check the attached file and the below measure.

Licensee count (more than 20 advisers only) measure: = VAR _newtable = ADDCOLUMNS ( VALUES ( Data[Licensee] ), "@countadvisers", CALCULATE ( COUNTROWS ( VALUES ( Data[Advisers] ) ) ) ) VAR _filternewtable = FILTER ( _newtable, [@countadvisers] > 20 ) RETURN COUNTROWS ( _filternewtable )

Re: Measure DAX Formula - to calculate number of instances a word appear in another column

umeshbanga — Wed, 22 Jun 2022 01:14:17 GMT

Thanks mate, it worked. How do I mark this as a solution?