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 which is required as per the criteria so that i can easly drag and drop.Table should be as below;

No of website=count of column Site Name(<>blank)

No of Inscope=count of the Site name(<> blank),candidate<>Yes(it has Yes and No),Status<>"*out of scope*" 

Remaining=No of website - No of Inscope

I really need your help in measures or dax but want a new table which can show this info.

 

Thanks,

Deepak

 

  • 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]

2 Replies

  • 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: