Forum Discussion
Highlight in scatter plot using field parameter
Measure:
Highlight Valgte Muligheder =
VAR Opslag = VALUES('Highlight indhold'[Valgmuligheder]) -- Captures all currently selected values
VAR Business_Cases = IF(CONTAINS(Opslag, 'Highlight indhold'[Valgmuligheder], MAX(HighligtGBS[HL - Business Cases])), 1, 0)
VAR Storbageri = IF(CONTAINS(Opslag, 'Highlight indhold'[Valgmuligheder], MAX(HighligtGBS[HL - Storbageri])), 1, 0)
VAR Bageri = IF(CONTAINS(Opslag, 'Highlight indhold'[Valgmuligheder], MAX(HighligtGBS[HL - Bageri])), 1, 0)
VAR Resultat = Business_Cases + Storbageri + Bageri
VAR MultiResultat = IF(Resultat > 0, 1, 0) -- Assign 1 if at least one condition is met
RETURN
IF(
HASONEFILTER('Highlight indhold'[Valgmuligheder]),
Resultat,
IF(ISCROSSFILTERED('Highlight indhold'[Valgmuligheder]), MultiResultat, BLANK())
)Let me know if this resolves the issue!
If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
Hi Again Kedar_Pande
I thing i found the issue. It is because I have a colomn with three different department for each ID in the same tabel where I check for my Field Parameter such as "Business Cases" and "Storbageri" etc.
The department is in a slicer, and when I select one department everything in your DAX formula works great !
Could you please tell have to add to your DAX if all departments are selected in the slicer it return 0.
So if there is non selected in the department slicer the measure should only give 1 to the ID's that have multiselected (F.eks. Business Cases and Storbageri) in the same department under each ID ?
I really hope you can help me, because you are so close to the answer 🙂
Hi Yilong Zhou
I have made a example .pbix file os the data, but somehow I can't see where to upload it in my reply to you. - do you know how to upload a file in here ?
When I was making the example file for you it came to me that I have a slicer that filters on three types of departments. And the issue with the formula and the dots that needs to be or not be hightlighted occurs when there is no selections in the department slicer.
So somehow I think I have to add this to the formula, so if there is no selected department in the slicer then all should be blank ()
- If you get what I mean by this, maybe you could help with that ?
Hi DK-C-87 ,
For some new community members, they don't have the permission to upload .pbix files. You may need to share file links via DropBox, One Drive, Drive or any other tool.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.