Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
2 years ago
Solved

Measure for Table Visual to Display Column Values

I have a table visual currently with 3 columns.

 

Region = Data Table Column

Within 35 Days = Measure that divides the number of rows with a specific value by the total number of rows.

KPI Status = Measure that displays "Expected KPI Met" or "KPI Breached" depending on  value of "Winth 35 Days" Measure.

But I want the "Region" column not to display the Region names if there are no rows.

So instead of having the "Region" column using the "Region" column called 

"Table: MSIP Time to Fill SLA'[Region]" for the Data Table, I have been trying to create a measure something like...

 

Test =
VAR CountTimeToFillRows = COUNTROWS('Table: MSIP Time to Fill SLA')
Return
IF(CountTimeToFillRows = 0, " ", {Display Region Names})
 
But I can get it to work.  Is this possible and if so, how?
Thanks in advance.
Need Help
  • Nilupul's avatar
    Nilupul
    2 years ago

    Try like this:
    Create a measure as below to check values are available to the measure

     

    Is Data Available = IF(ISBLANK([KPI Status]) && ISBLANK([Within 35 Days]) , 0,1)

     

    Then put this measure as a visual level filter . After that filter with is 1.  

    If is blank not work try with [KPI Status] = ""

2 Replies

  • Nilupul's avatar
    Nilupul
    Frequent Visitor
    2 years ago

    Try like this:
    Create a measure as below to check values are available to the measure

     

    Is Data Available = IF(ISBLANK([KPI Status]) && ISBLANK([Within 35 Days]) , 0,1)

     

    Then put this measure as a visual level filter . After that filter with is 1.  

    If is blank not work try with [KPI Status] = ""

    • StuartSmith's avatar
      StuartSmith
      Power Participant
      2 years ago

      Thanks, I had to change the measure a bit, but your solution gave me a base code to get it working. 👍