DAX Formula Filters

Hi guys,

In 1 column I have a number of regions ( 1 to 4) and in another column I have incident class ( 1,2,3,4,5)

I am trying to create a card with the total number of Region 1 and incident class 1 (for example). See below columns. Basically how many (count)incident class = 1 has region 1.

I am having mental DAX block today and can’t get it right.

I hope I am making sense, first question in the forum - hope is Ok.

Thanks

Federico

@Fp1967,

Welcome to the forum - great to have you here!

In general, you will get the best response if you post a copy of your PBIX file and a mockup of the result you want to see. For your measure, try this:

Measure =

CALCULATE (
    COUNTROWS ( Table ),
    FILTER ( Table, Table[Incident Class] = 1 && Table[Ops Region] = "Reg 1" )
)

I hope this is helpful.

  • Brian

Thanks for posting your question @Fp1967. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread.

Here is a potential list of additional information to include in this thread; demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.

Thank you Brian,

It works to perfection.

Regards,

Federico

@Fp1967,

My pleasure - glad to hear that worked well for you.

  • Brian