Converting a PowerBI Funnel formula

[doormat63]

Hi! How can I convert this DAX code for a funnel in Power BI into a Quicksight calculated field? Or how is the best way to deal with this data in Quicksight?

[Giridhar.Prabhu]

Hi @doormat63

Welcome to the community!

You can create a calculated field using the IN function to look at the selection in the parameter and select the required metric.

Filter with all values selected return no data

Hi all, I have the following scenario. let me explain you the current setup in case this helpa to understand the issue. I mostly want to understand if there is a workaround. QS dataset: This includes dataset parameters. QS Analysis: This includes 3 filter. Scenario A(This works): In the analysis: Cascading filters enabled These filters(values) are from a single QS dataset(SPICE) Select region ‘EU’, Select country(I select 2 values out of three: So I select ‘BE’, ‘DE’ and I excluded from …

regards,
Giri

[Brett]

Hi @doormat63,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @doormat63,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!