qlik expressions to dax

[Anonymous]

Guys,

iam working on Qlik migration to powerbi report. Someone please help me how to get expressions used in qlik view report and way to convert into powerbi DAX measures.

[parry2k]

@Anonymous well you have to share what expression you need help with?

[freddyhowden]

Hi @parry2k , I also have the same question...

The three expressions that I am looking to convert from Qlik Sense to Power Bi are below. Do you think you will be able to help? Tks, Freddy

Count(if(EXPERIENCE_RATING ='Sad',EXPERIENCE_RATING))/Count('Sad')

Count(if(REMEDY_SLA_MET='Within SLA',REMEDY_SLA_MET))/count('Within SLA')

Count({<REMEDY_SLA_MET= {'Within SLA'}>} REMEDY_SLA_MET)/count(REMEDY_SLA_MET)

[parry2k]

@freddyhowden can you simply tell me what is your table and what your calculation suppose to do and will get you the measure. I don't have interest in understanding qlik formula expressions 😛

[freddyhowden]

@parry2k , yes sure! I am trying to put a graph together that shows % of tickets with Experience Rating as Sad. (May decide to add Happy & Neutral after) Hopefully the table, graph below help. 

[parry2k]

@freddyhowden still not sure what you actually want? So let's if you have following data in a month

sad = 10

happy = 20

Neutral = 30

so sad % for that month will be 10 / 60, is this what you want ?

or something else?

[freddyhowden]

Yes that’s exactly what I’m looking for!

[parry2k]

@freddyhowden create following 3 measures, although you can achieve the same in one measure as well

Count = OOUNTROWS ( Table )

Total Count = CALCULATE ( [Count], ALLSELECTED ( Table[Experience_Rating] ) )

% Experience Rating = DIVIDE ( [Count], [Total Count] )

Change format of % Experience Rating measure to "%" and on line chart, drop month on x-axis, experience rating on Legend and % of Experience Rating on values and you are good to go

[freddyhowden]

That works great, thanks Parry! The graph now displays Positive, Neutral and Negative VOC with the correct valaues.

If I use the filter to just show one of these categories the graph line levels out at 100% for all of them. Is there an expression I could use that would allow 'negative' values to remain as they should be when I filter?

[parry2k]

@freddyhowden change ALLSELECTED to ALL and that will do it.