Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello Community,
I need to filter in a visual object all the elements that have contemporarily these two conditions:
STAGE NAME: RECEIVING
CONDITION: APPROVED
&
STAGE NAME: SAMPLING
CONDITION: ONLINE
If I select the filter by stage name and by condition it filters everything that has receing approved and online and sampling approved and online instead I would like to display only the items that have receiving approved and sampling online.
Can someone kindly help me?
Thanks in advance!
Solved! Go to Solution.
Hi @ss89
On the table that you have on the question add the measure to only see the cases where the condition is valid.
Or you can add the measure as a filter in the visual and select "is greater than" 0.
Best regards
Bruno Costa | Impactful Individual
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
You can also check out BI4ALL's website and our data solutions!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Hello @ss89
My suggestion is that you create a measure that show the number os rows in the first or second condition.
Something like this:
Total_1 =
CALCULATE(
COUNTROWS('factTable'),
or(
AND(Stage Name = "RECEIVING" , Condition = "APPROVED"),
AND(Stage Name = "SAMPLING" , Condition = "ONLINE")
)
)
If you need more help please sahre a pbix with some dummy values.
Best regards
Bruno Costa | Impactful Individual
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
You can also check out BI4ALL's website and our data solutions!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Hello,
thanks for your propomt reply!
In this way, however, I get a total as a result; I would instead need to have only the list of all the activities that have these combined filters.
Thanks in advance!
Hi @ss89
On the table that you have on the question add the measure to only see the cases where the condition is valid.
Or you can add the measure as a filter in the visual and select "is greater than" 0.
Best regards
Bruno Costa | Impactful Individual
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
You can also check out BI4ALL's website and our data solutions!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Hi @onurbmiguel_ ,
thanks for your tips, it works!
The last thing: items that meet the two conditions at the same time (RECEIVING=APPROVED & SAMPLING=ONLINE) should be displayed only the item that has SAMPLING=ONLINE otherwise I risk having duplicates in the display
I would like to visualize only the lot_id with Sampling online.
Thanks in advance!
hi @ss89
Try this one:
Total_1 =
CALCULATE(
Distintcount(Lot_ID),
or(
AND(Stage Name = "RECEIVING" , Condition = "APPROVED"),
AND(Stage Name = "SAMPLING" , Condition = "ONLINE")
)
)
like this the total will be right
Best regards
Bruno Costa | Impactful Individual
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
You can also check out BI4ALL's website and our data solutions!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Hi @onurbmiguel_ ,
the formulas does not satisfy both the rules; all these stages have "Complete" as CONDITION column. I would like to visualize only the LOT_NUMBER that have both STAGE_NAME=RECEIVING, CONDITION=APPROVED & STAGE_NAME=SAMPLING, CONDITION=ONLINE.
Thank you
Hi @onurbmiguel_ ,
I would like to share the pbix with some dummy values.
How can I insert the pbix in the reply?
Thanks in advance!
All the best
Hi @onurbmiguel_ ,
the following error message appears:
"Too many arguments passed to the DISTINCTCOUNT function. A maximum of 1 arguments are allowed"
HI @ss89
Nice that i was helpful , can you accept my solution?
Best regards
Bruno Costa | Impactful Individual
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
You can also check out BI4ALL's website and our data solutions!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Hi @ss89
Sorry the delay, please reply alway in the last message otherwise it will be difficult to see your feedback.
some notes:
i will wait for your feedback
Best regards
Bruno Costa | Impactful Individual
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
104 | |
99 | |
99 | |
38 | |
37 |
User | Count |
---|---|
158 | |
124 | |
76 | |
74 | |
63 |