New Dynamic Table

[deepakkhairnar]

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 · Accepted solution]

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

Perfect..!! Thanks it is working as i want..Thanks again..