Forum Discussion

monishd's avatar
monishd
Frequent Visitor
1 year ago
Solved

How to return a TABLE in PowerBi

I have a measure that "counts" the number of rows which contains certain strings. I want a drill through for the visual that shows the count. How can I filter the table to show only those rows which ...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    monishd Create a calculated column in your IncidentTable that checks if the short_description contains any of the specified strings.

    IncidentTable[IsDiskSpaceRelated] =
    IF(
    CONTAINSSTRING(IncidentTable[short_description], "Extend Disk") ||
    CONTAINSSTRING(IncidentTable[short_description], "Increase Disk Space") ||
    CONTAINSSTRING(IncidentTable[short_description], "Space") ||
    CONTAINSSTRING(IncidentTable[short_description], "Clean and Remove") ||
    CONTAINSSTRING(IncidentTable[short_description], "Free Space") ||
    CONTAINSSTRING(IncidentTable[short_description], "Capacity is Full") ||
    CONTAINSSTRING(IncidentTable[short_description], "Increase the VM Capacity") ||
    CONTAINSSTRING(IncidentTable[short_description], "Requesting to increase"),
    1,
    0
    )

     

    Use this calculated column to filter the table visual. You can do this by adding a filter to the table visual where IsDiskSpaceRelated equals 1.

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

monishd Create a calculated column in your IncidentTable that checks if the short_description contains any of the specified strings.

IncidentTable[IsDiskSpaceRelated] =
IF(
CONTAINSSTRING(IncidentTable[short_description], "Extend Disk") ||
CONTAINSSTRING(IncidentTable[short_description], "Increase Disk Space") ||
CONTAINSSTRING(IncidentTable[short_description], "Space") ||
CONTAINSSTRING(IncidentTable[short_description], "Clean and Remove") ||
CONTAINSSTRING(IncidentTable[short_description], "Free Space") ||
CONTAINSSTRING(IncidentTable[short_description], "Capacity is Full") ||
CONTAINSSTRING(IncidentTable[short_description], "Increase the VM Capacity") ||
CONTAINSSTRING(IncidentTable[short_description], "Requesting to increase"),
1,
0
)

 

Use this calculated column to filter the table visual. You can do this by adding a filter to the table visual where IsDiskSpaceRelated equals 1.