Want to see the content with no count

[vishu263]

Hello,

Under Column Incident Priority, there are mainly four values, 1-Critical, 2-High, 3-Moderate, 4-Low

There are no critical incidents reported for the selected period. And hence when I drag this column into the table, it simply doesn't show 1-Critical. 

However, the client want to see all priorities regardless there is any incidents reported or not.

I tried selecting option 'Show Items with no data' but that doesn't work.

Also, I don't have access to create a new master table. Does anyone know any other option to get this done?

[TheoC]

Hi  @vishu263

The way in which you need to manage this process is establishing a new table called "Priority" in your data model and have all four priorities in a column within the new Priority table.  This will act as your dimension table.

Create a relationship between the dimention table you just created (Priority) and the Incidents table.  In your visual, make sure you use the dimension table column with the list of Priorities and then you can use the Total Incidents from your fact table as the basis of your count.

You can create measure like "Total Incidents = COUNTROWS ( IncidentsTable )" and drag this in to the table visual after you have dragged in the Prioritis column from the new dimension table Priority.  You can use "Enter Data" to add a quick table with ease. Just make sure to create the relationship from dimPriority to the fact table.

 

Hope that makes sense  

Theo

🙂

[vishu263]

Hi Theo,

Thank you for your response. However, I am using PBI Dataset as a source and do not have the option to "Enter Data" or to load a new table. 

Is there any other alternative solution for this problem?

Thanks.

[TheoC]

Hi @vishu263 

Can you create a new DAX table:

IncidentPriorityTable = 

DATATABLE (
    "Incident Priority", STRING,
    {
        { "1 - Critical" },
        { "2 - High" },
        { "3 - Moderate" },
        { "4 - Low" }
    }
)

Hope this helps!

Theo