Not Selected Value Table

[Anonymous]

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

[lc_finance · Accepted solution]

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

[Anonymous]

well done

easier than i thought

thank you @lc_finance !!!