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...
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] = ""

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. 👍