Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need to trasform qlik set analysis in dax language. Set analysis is offers a way of defining a set (or group) of data values that is different from the normal set defined by the current selections.
The original formula is something like this:
count( {<[Field1={'P'},
[field2]={">9"}>} distinct [field3])
Should I use calculate?
Solved! Go to Solution.
Hi @Giada_Togliatti ,
Try this:
Measure = CALCULATE(DISTINCTCOUNT('Table'[field3]),FILTER('Table','Table'[field2]>1&&'Table'[field1]="p"))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi all,
I have the same question but a bit complex. If someone can help me please how to implement the same in POWER BI:
Outgoing Products =
count( distinct
{<ImportID={$(v_Sequence_B)},
ProductID=P({ < ImportID={$(v_Sequence_B)}>}ProductID)>
*
< ProductID=P({< ImportID={$(v_Sequence_A)}>}ProductID)>} ProductID
)
I have also 2 filter objects in QlikView, Where v_sequence_A equals to the selected value of the first filtered object and v_sequence_B equals to the selected value of the second filtered object.
So, at the first part the query (ProductID=P({ < ImportID={$(v_Sequence_B)}>}ProductID)) must give me all ProductID that are equal to v_sequence_B and at the second part (ProductID=P({< ImportID={$(v_Sequence_A)}>}ProductID)) will give me all ProductID that are equal to v_sequence_A and finally (>*<) it will count me all ImportIDs that are in common respecting both situations.
The difficult part of this query is that in power bi (at least as i know) is not possible to retrive the value selected by the filteres in oreder to use it as in another query.
Is there a way to get common values for a specific period by not considering the value selected from the filter objects?
Thans,
EHSAN
@Giada_Togliatti better post sample data and expected output to get the solution.
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 I need to define a set (or group) of data values that is different from the normal set defined by the current selections and I should have as an output the result of a measure
field1 | field2 |
p | 1 |
q | 2 |
If field1 is p and field2 is >1 then calculate count of something called field3
Hi @Giada_Togliatti ,
Try this:
Measure = CALCULATE(DISTINCTCOUNT('Table'[field3]),FILTER('Table','Table'[field2]>1&&'Table'[field1]="p"))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |