Forum Discussion
Concatenated tooltip - on a bubble plot (or anywhere)
- 1 year ago
Try this new code:
Emails included = VAR _Emai1sInPeriodPerContact = SUMMARIZE ( 'Emai1s and Contacts', 'Emails and Contacts '[contactid], 'Emails and Contacts '[blc_subject], "How Many Emails", SUM ( 'Emai1s and Contacts'[Was Delivered] ) ) VAR RETURN CONCATENEX ( SUMMARIZE( FILTER ( _Emai1sInPeriodPerContact, [How Many Emails] = 'Number of Emails'[Number of Emails Value] ), 'Emails and Contacts '[blc_subject]) , 'Emails and Contacts '[blc_subject], ", " )
Hi s--turn ,
If you allow me first of all you have a huge problem on your data model that is the bidirectional filters on all your tables, do not apply this to your calculations since this will make your results not be correct because of the filtering of dimensions by facts.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Thanks - seems I have some bad habits to unlearn! It seems like this is quite a lot to untangle, so I'm going to pause work on this report for the time being, and return to it later. It will take time to mock up a .pbix file, so again that may have to wait. I appreciate your guidance so far.