Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

qlik expressions to dax

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.

9 REPLIES 9
parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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)

@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 😛



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

@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. PowerBi.PNG

@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?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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

@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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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?

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.