Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Krijgerss21
Helper II
Helper II

DAX meassure for card visuals

i need some help

 

if got a list of company's with contact persons. now i want to show the contact person in a card visual if i select a company from the list but if i dont select any company i want the card visual empty so not a blank or the first contact person just a blank card with only the catorgy label visual and if i select a company than i want to see the "Catogrylabel" and the "contactperson"

3 REPLIES 3
DOLEARY85
Super User
Super User

Hi,

 

try this:

 

Measure  = if(ISBLANK(SELECTEDVALUE('Table (20)'[contactperson])),"",SELECTEDVALUE('Table (20)'[contactperson]))
 
DOLEARY85_0-1681217570866.png

 

DOLEARY85_1-1681217583492.png

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍


 
 
Sudhir_M1992
Frequent Visitor

Could you please share some dummy data so that we can take a look and help you with this.

company        contactperson

name               name

name               name

name               name

name               nema

name               name

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors