Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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]
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]
Perfect..!! Thanks it is working as i want..Thanks again..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |