How do I create a measure with filters?

[jonnyA]

I'm trying to create a measure with filters.

For example: my dataset has a "note_Id" and I need to figure out a way to create a measure that has my "Note_ID", but only the Note ID's that have Modifers 95 and GT.

Maybe the screenshots will help ... As you can see from the screenshots the table is only showing Note ID's that have Modifier's 95 and GT.

Continued, see how I have checked every filter that has a 95 or GT?  That is what I need to bring back in this filtered Measure I am trrying to create.

Why am i trying to do this?  Because I am going to need to divide a filtered Note ID, divided by, another Filted Note ID.

[parry2k · Accepted solution]

@jonnyA I think I used the wrong column in the DAX, try this

Count 95 and GT = 
CALCULATE ( 
COUNTROWS ( Table ), 
Table[Modifier] IN { "95", "GT" } 
)

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@jonnyA try this in % calculation

% = DIVIDE ( COALESCE ( [95 and GT Measure], 0 ), [Denominator Measure], 0 )

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[jonnyA]

@parry2k ,

Hey, thank you for your answer!  The formula did work for the %.

Another question ... is there a way to make the "95 and GT" measure show "0" when it is blank?  When "95 and GT" measure are blank the "%" is also blank.  I'm thinking if we can make the blanks show up as "0" then the % will display!  Thank you!

[parry2k · Accepted solution]

@jonnyA wrap it in KEEPFILTERS

Another measure = 
CALCULATE ( 
COUNTROWS ( Table ),
KEEPFILTERS ( NOT ISBLANK ( Table[CPT] ) ),
KEEPFILTERS ( NOT ISBLANK ( Table[Billed_CPT] ) )
)

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@jonnyA try this:

Another measure = 
CALCULATE ( 
COUNTROWS ( Table ),
NOT ISBLANK ( Table[CPT] ),
NOT ISBLANK ( Table[Billed_CPT] ) 
)

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[jonnyA]

My #'s are close, but not quite working.

If you look at the right matrix, where it is highlighted, i dont understand why it is showing "10" for all Note ID's?  The matrix on the left is broken down individually.

[jonnyA]

@parry2k , I have another step to what I am trying to accomplish.

Part 2.

It's another measure using the same "Note_ID" with the following filters ... 

• CPT is not Blank
• Billed_CPT is not (Blank)

Do you know how why write a measure for that?

Thank you in advance! 🙂

[parry2k · Accepted solution]

@jonnyA I think I used the wrong column in the DAX, try this

Count 95 and GT = 
CALCULATE ( 
COUNTROWS ( Table ), 
Table[Modifier] IN { "95", "GT" } 
)

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[jonnyA]

@parry2k ,

Thank you again for all of your help today, I really appreciate it!

Ok, Final question ... The "Count of 95 and GT" measure.  I have many that are blank.  Is there a way to make them show as "0" when they are blank?

The reason I want to show "0" when blank is because I want the "% of Encounters to Telehealth" to show a %.  Where the "Count of 95 and GT" are blank, then a % does not show up.

Thank you! 🙂

[parry2k]

@jonnyA you should write a measure to filter 25 and GT

Count 95 and GT = 
CALCULATE ( 
COUNTROWS ( Table ), 
CONTAINSSTRING(Table[Note Id], "95") ||
CONTAINSSTRING(Table[Note Id], "GT")
)

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[jonnyA]

@parry2k 

Thank you for your quick response to my issue!

The measure you gave me worked a little bit but my #'s are still off.

The Totals on the left matrix should match the totals on on the right matrix.  The providers circled  are for the same provider.  See how so many more CPT's on the left than the right.  i am not sure why that is?  I appreciate the help in advance!  Thank you 🙂 !