Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • lc_finance's avatar
    lc_finance
    6 years ago

    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

lc_finance's avatar
lc_finance
Solution Sage
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

well done

 

easier than i thought

 

thank you lc_finance !!!