Disconnected Sicer with Different Data Types

[Anonymous]

Hello all,

I am building out a matrix and one of the requirements for this matrix is to have the measures in the rows section of the table. I was able to achieve this by creating a disconnected table and using the SELECTEDVALUES function. The problem I ran into is that the mesaures in the matrix are a mix of whole numbers and percentages and the percentages appear as 0. I checked the percebtage measure in a seperate table and it works so my guess is that the method I used only allows for one data type. Is there a way around this?

Value Selection = 
VAR Selection = SELECTEDVALUE('Disconnected Table'[Measures], "All")

Return

SWITCH(TRUE(),
    Selection = "Webinar Registrants", [Webinar Registrants],
    Selection = "Webinar Attendees", [Webinar Attendees],
    Selection = "Webinar Attend Rate", [Webinar Attend Rate],
    Selection = "Webinar Enrollments", [Evergreen Webinar Enrollments],
    Selection = "Webinar Enroll Rate", [Evergreen Enroll Rate]
)

[TomMartens]

Hey,

I'm wondering if this will provide what you are looking for:

Mark the matrix table and in the formatting section  simply switch the property "Show on rows" from the Values band.

Regards,

Tom

[Anonymous]

Hi Tom,

Thanks for your response. Unfortunetly, that didn't work. I'm still getting 0 for values that should be percentages.

[TomMartens]

Hey,

do you use the original measures and did you check the "Format" option for each value from the formatting ribbon from the "Modeling" menu:

Regards,

Tom

[Anonymous]

Yes. All the measures that are formatted as "Whole Number" appear. Measures that are formatted as "Percentages" come back as 0.

[TomMartens]

Hey,

can you please create a PBIX file with sample data, upload the file to onedrive or dropbox, and please share the link.

Regards,

Tom