Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Pop up in Parameter in direct Query

Hi All,   I am using direct query. I have used parameters where client will enter some random ID's to check the repective values.    Now I have some ID's which doesn't contain any data. Now i wan...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous,

    At first, current power bi not able to show the window to notice some selected items that do not exist correspond records.
    For your scenario, I'd like to suggest you create a measure formula to compare with table records and selection value to display the not matched selections.

    DAX EXCEPT function 

    DAX CONCATENATEX funciton 

    After these steps, you can use this measure on a card that named not contains records ids to display them.

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous,

At first, current power bi not able to show the window to notice some selected items that do not exist correspond records.
For your scenario, I'd like to suggest you create a measure formula to compare with table records and selection value to display the not matched selections.

DAX EXCEPT function 

DAX CONCATENATEX funciton 

After these steps, you can use this measure on a card that named not contains records ids to display them.

Regards,
Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous mahoneypat ,

 

Yes we can achieve that in card with the suggetions which you have provided. But Actually I would like to have the current power bi  to show the window to notice some selected items that do not exist correspond records.

And the reply from Anonymous  it seems like Power BI Doesn't have that ability as of now.

Thanks for your Suggestions.

 

Regards,

Prakash M