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.
Hello community, I'm trying one thing and I don't know where I'm making the mistake, for example, I have an array with three columns "name", "phone", "photo"
and on the other hand a card with the name and another multiple card with the photos.
when I select a record from the table it gives me the name and photo.
The problem is that I need that if there is none selected do not show me anything. he tried the
It works IF and HASONEFILTER but does not let me build the new measure with the columns I need, algien can tell me how to do it?
I put together photo in case I do not explain myself well.
Advance Thanks
Solved! Go to Solution.
Hi @Syndicate_Admin ,
Here are the steps you can follow:
1. Create measure.
Measure_Nombre =
IF(
HASONEFILTER('Table'[Nombre]),MAX('Table'[Nombre]),BLANK())
Measure_Foto =
IF(
HASONEFILTER('Table'[Nombre]),MAX('Table'[Foto]),BLANK())
2. Result:
When not selected:
Select a row:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Syndicate_Admin ,
Here are the steps you can follow:
1. Create measure.
Measure_Nombre =
IF(
HASONEFILTER('Table'[Nombre]),MAX('Table'[Nombre]),BLANK())
Measure_Foto =
IF(
HASONEFILTER('Table'[Nombre]),MAX('Table'[Foto]),BLANK())
2. Result:
When not selected:
Select a row:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Syndicate_Admin , you can use isfiltered
refer video from guyinacube - https://www.youtube.com/watch?v=sXn-QZqLD-8
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |