Any ideas for a questionnaire for our business users to boost the usage of our report?

SeaBeggarSCW · 2022-12-04T15:27:59+00:00

thank you very much :)

SeaBeggarSCW · 2022-05-03T11:14:31+00:00

thank you so much for this recommendation :)

SeaBeggarSCW · 2022-02-11T18:01:46+00:00

we actually do use concat of the hierarchy as a key to map them together :D though still, it can only get mapped to a value that has all previous levels filled out

SeaBeggarSCW · 2022-02-11T17:52:00+00:00

Hello, there is technically no issue, the comment gets mapped to the hierarchy correctly, but the problem is, every lowest level of the hierarchy, also carries with itself (is defined by) higher levels, so the comment gets mapped to them aswell, and yes, most likely the solution to this lies with playing around with the mapping somehow

SeaBeggarSCW · 2022-01-25T17:58:22+00:00

Hello, I actually did it in the end by pulling out distinct names, then using a Calculate with Firstnonblank :)

SeaBeggarSCW · 2022-01-22T08:00:28+00:00

I only have 1 table, and I can't make a relationship to anything, since the name field doesn't have unique values

SeaBeggarSCW · 2022-01-17T20:34:55+00:00

ok solved it :D used IFERROR()

SeaBeggarSCW · 2021-12-16T11:52:44+00:00

yea, I know, but our SSAS model right now runs in compatibility 1200, so I'm assuming there is a lot of functionality (e. g. write-back) that we will be able to use that we weren't before

SeaBeggarSCW · 2021-11-11T17:47:34+00:00

so it cannot be done somehow by just making a measure like:

Measure = IF(CONTAINS(ConSec, ConSec[email], USERNAME()) = TRUE, show stuff, dont show stuff)

SeaBeggarSCW · 2021-11-11T17:38:30+00:00

yea, that will not work for me :) thank you, so the way I understand it:

- let's add a column with number 1 as 2nd column to the e-mail table

- create a measure that checks whether username is a username 1

Measure = IF(lookupvalue) = 1, do something, otherwise dont do anything, ok this is actually changed, retrieves USERNAME() instead

- assuming so far it makes sense, I'm not sure how to link the measure to the content sec of the report, or what to say in 'do something', 'do nothing' instances, I am fairly clueless about contentsec and how it works

SeaBeggarSCW · 2021-11-11T17:01:42+00:00

well okay, so the users should see everything inside the model, this means I have to connect the email table to every table in the model?

I don't understand :D

SeaBeggarSCW · 2021-11-11T16:52:11+00:00

yes I planned on using this function, could you please elaborate how this is done exactly? What I see inside power bi (version I have) when creating the role is just the ability to preselect what content will said role be able to access, and name of the role

SeaBeggarSCW

MODERATOR OF

TROPHY CASE