Forum Discussion

kadifr2008's avatar
kadifr2008
Frequent Visitor
8 years ago
Solved

How to create a table out of a dynamic visual

I have a problem, i have create a visual table with a conditional formating and now i am trying to create another table out of the previous visual, by counting how many are red, green etc... can BI d...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi kadifr2008,

     

    Check this:

     

    Create a new table with expression:

     

    Count Color Table =
SELECTCOLUMNS (
    FormatColor,
    "Call in Red", CALCULATE (
        COUNT ( FormatColor[Call in] ),
        FILTER ( FormatColor, FormatColor[Call in] > 0 )
    ),
    "Call in Green", CALCULATE (
        COUNT ( FormatColor[Call in] ),
        FILTER ( FormatColor, FormatColor[Call in] = 0 )
    ),
    "Attrition Red", CALCULATE (
        COUNT ( FormatColor[Attrition] ),
        FILTER ( FormatColor, FormatColor[Attrition] > 0 )
    ),
    "Attrition Green", CALCULATE (
        COUNT ( FormatColor[Attrition] ),
        FILTER ( FormatColor, FormatColor[Attrition] = 0 )
    )
)

     

    Thanks,
    Xi Jin.

kadifr2008's avatar
kadifr2008
Frequent Visitor
8 years ago

Here is the condition:

i am unsing the if statement:

 column=if(sheet1[count)<=13,"red","Green), i have so blank row, and the formula is counting that as red, and i dont want that, how to make my formula ignore the blanck row. thank you