Forum Discussion
DYNAMICALLY CHANGING CARD TOPICS
I Have a card visual which i use to show my team engagement.it shows how many are engaged for the week and how may not.now i have a slicer which has all my projects .When i choose a project it should only show employee engaged,not employee disengaged.
The Idea behind this is when a particular program is selected it should show only the people engaged.Others are engeged elsewhere ,not disengaged.
Hi ARUNC12 , You could create a dax measure for selecting the engaged one and then use it on the visual
Example : Engaged Employees =
CALCULATE(
COUNTROWS(Employees),
Employees[Status] = "Engaged"
)
This will dynamically pick up the required
If this post helped please do give a kudos and accept this as a solution
Thanks In AdvanceHello ARUNC12
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
6 Replies
- Akash_Varuna
Super User
Hi ARUNC12 , You could create a dax measure for selecting the engaged one and then use it on the visual
Example : Engaged Employees =
CALCULATE(
COUNTROWS(Employees),
Employees[Status] = "Engaged"
)
This will dynamically pick up the required
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance Hi Akash,
The engagement is still showing Ok.The card will show all "Engaged" and "Disengaged" fine when i select Week Filter.but when i click on the Program slicer,i do not want to confuse viewers with "Disengaged" information on Card.Let me know if i make any sense.or else i can share my Dashboard.
v-karpurapudCommunity Support
Hi ARUNC12
Thank you Akash_Varuna for your response.Thank you for reaching out to the Microsoft Fabric Community Forum. We understand your need for dynamically changing card topics.
Please try the following DAX formula:
Engaged Employees =
VAR IsProgramFiltered = ISFILTERED(Program[ProgramName])
RETURN
CALCULATE(
COUNTROWS(Employees),
Employees[Status] = "Engaged",
IsProgramFiltered )If the issue persists, kindly share the dashboard so we can better understand the problem and assist you more effectively.
If my response has resolved your query, please mark it as the Accepted Solution to help others. Additionally, I would appreciate a 'Kudos' if you found my response helpful.
Thank you!
- v-karpurapud
Hello ARUNC12
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- v-karpurapud
Hello ARUNC12
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you. - v-karpurapud
Hello ARUNC12
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
