Forum Discussion

deepakkhairnar's avatar
deepakkhairnar
Frequent Visitor
8 years ago
Solved

New Dynamic Table

Hello Friends, I have a data sheet with multiple columns like site name,change request,block mode,status,candidate etc... what i want is a new table in BI which will show me the count of table whic...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    deepakkhairnar,

     

    You may drag measures below to a Table visual.

    No of website =
CALCULATE (
    DISTINCTCOUNT ( Table1[site name] ),
    NOT ( ISBLANK ( Table1[site name] ) )
)

    No of Inscope =
CALCULATE (
    DISTINCTCOUNT ( Table1[site name] ),
    NOT ( ISBLANK ( Table1[site name] ) ),
    Table1[candidate] <> "Yes",
    Table1[status] <> "*out of scope*"
)

    Remaining =
[No of website] - [No of Inscope]
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

deepakkhairnar,

 

You may drag measures below to a Table visual.

No of website =
CALCULATE (
    DISTINCTCOUNT ( Table1[site name] ),
    NOT ( ISBLANK ( Table1[site name] ) )
)

No of Inscope =
CALCULATE (
    DISTINCTCOUNT ( Table1[site name] ),
    NOT ( ISBLANK ( Table1[site name] ) ),
    Table1[candidate] <> "Yes",
    Table1[status] <> "*out of scope*"
)

Remaining =
[No of website] - [No of Inscope]
deepakkhairnar's avatar
deepakkhairnar
Frequent Visitor
8 years ago

Perfect..!! Thanks it is working as i want..Thanks again..:smileyhappy::smileyvery-happy: