Power BI measure

[HPS1RT]

Hello Everyone,

I am newbie to Power BI. I have a table with SREQ ID and Project ID. Please refer the below Image.

When I apply the filter on Project ID that contains "E" or "G", it should give me the total count of SREQ IDs. Please refer below Image:

Now I just wanted to create dax measure, so that it gives count of SREQ ID's as 3 in this case. Please note that I wanted to apply the filter on the visual, don't want to define it inside dax.

Thank you

[Anonymous]

Hi @HPS1RT ,

I don't fully understand what you mean, is it the following result?

Please feel free to correct me and provide more information if I have misunderstood you!

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[HPS1RT]

Hello @Anonymous @lbendlin ,

Thank you for your answer. Here is my measure:

Measure = CALCULATE(DISTINCTCOUNT('Table'[SREQ ID]), CONTAINSSTRING( 'Table'[Project ID], SELECTEDVALUE('Table'[Project ID])))

I need to get the count of 3, if select the filter that contains E or G. But it is giving me 5. Can you please help me to correct this measure?
Thanks in advance:)

[Anonymous · Accepted solution]

Hi @HPS1RT ,

I think there is a misconception that measure is based on context. It's true that you are using selectedvalue for filtering in your measure, but it's used for slicer. You can try copy table and then implement it without DAX:

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[HPS1RT]

Thank you @Anonymous 
That worked:)

[lbendlin]

Please note that I wanted to apply the filter on the visual, don't want to define it inside dax.

Visual Calculations use DAX too (plus some extra functions).

Consider using SEARCH in your visual calculation formula.