Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
@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.
@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.
@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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
91 | |
84 | |
76 | |
65 |
User | Count |
---|---|
145 | |
109 | |
109 | |
102 | |
96 |