Forum Discussion
DYNAMICALLY CHANGING CARD TOPICS
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.
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.
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!
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.