Forum Discussion
Not Selected Value Table
Hi,
here is my problem :
let's say i have :
- 1 Dimension table with 10 users --> DIM_USERS
- 1 Dimension table with 50 reports --> DIM_REPORTS
- 1 Fact table with logs --> TAB_LOGS
If i select one report, let's say "Report A", i can easily display users that did access the report.
But if i wanna display the lads who did NOT...
I would like those lazy users to be listed in a dynamic table.
That means that the solution consisting of a CONCATENATEX measure with the list "lazyguy1, lazyguy2, ..." isn't ok.
I really need to have those guys listed in a table.
I tried to play with the EXCEPT function. I guess this is the good path to the solution. But i can't figure out how to set my "right" table.
EXCEPT(Table_left;Table_right)
--> EXCEPT(SELECTCOLUMNS(DIM_USERS;"LazyLads";DIMUSERS[UserID]); ??? )
Thanks for you help
A lazy guy
Hi Anonymous ,
Here is the calculated measure you can create for that:
Lazy User = var selectedReport = SELECTEDVALUE(DIM_REPORTS[Reports]) VAR selectedUser = SELECTEDVALUE(DIM_USERS[Users]) VAR selectedUserUseSelectedReport = IF( COUNT('TAB_LOGS'[Date])>=1 ,TRUE,FALSE) RETURN IF (selectedUserUseSelectedReport, BLANK(), "Lazy")Here is a screenshot of what it will look like:
And finally, here you can download the Power BI template.
Let me know if this works for you,
LC
Interested in Power BI templates? Check out my blog at www.finance-bi.com
2 Replies
Hi Anonymous ,
Here is the calculated measure you can create for that:
Lazy User = var selectedReport = SELECTEDVALUE(DIM_REPORTS[Reports]) VAR selectedUser = SELECTEDVALUE(DIM_USERS[Users]) VAR selectedUserUseSelectedReport = IF( COUNT('TAB_LOGS'[Date])>=1 ,TRUE,FALSE) RETURN IF (selectedUserUseSelectedReport, BLANK(), "Lazy")Here is a screenshot of what it will look like:
And finally, here you can download the Power BI template.
Let me know if this works for you,
LC
Interested in Power BI templates? Check out my blog at www.finance-bi.com