Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi all!
I have the following:
Tables:
Table_StoreList
Table_CustList
Table_Feedback_Received
Table_Cust_with_Feedback - new table derived from DAX Measure: Table_Cust_with_Feedback = DISTINCT('Table_Feedback_Received'[CUSTID])
Relationships:
Table_Cust_with_Feedback[CustID] -> Table_CustList[CustID]
Table_Feedback_Received[CustID] -> Table_CustList[CustID]
Table_CustList[StoreID] -> Table_StoreList[StoreID]
Measures:
Table_Cust_with_Feedback[Cust_with_3_or_more_feedback] = CALCULATE(COUNTROWS('Table_Cust_with_Feedback'), FILTER( 'Table_Cust_with_Feedback', 'Table_Cust_with_Feedback'[Number_of_Feedback_Received]>=3))
Issue faced:
I have a slicer "StoreID" on the report page and a Card [Cust_with_3_or_more_feedback] that does not respond to changes in the slicer i.e. it shows the total number of customers with 3 or more feedback for all stores no matter what the selection in the slicer.
Can anyone point out my mistake?
Regards,
Yee Pin
Solved! Go to Solution.
I have tried modifying the direction in the relationship and it does not seem to work for me.
I have realized that the slicer does not affect any of the card visuals from Table_Cust_with_Feedback so I have deleted the Table_Cust_with_Feedback and created the following within Table_CustList:
Calculated columns
Table_CustList[Number_of_Feedback_Received] = CALCULATE(DISTINCTCOUNT('Table_Feedback_Received'[FeedbackID]), FILTER('Table_Feedback_Received', 'Table_Feedback_Received'[CustID] = 'Table_CustList'[CustID]))
Measure
Cust_with_3_or_more_feedback = CALCULATE(COUNT('Table_CustList'[CustID]), FILTER('Table_CustList', 'Table_CustList'[Number of Feedback_Received]>=3))
Card visual "Cust_with_3_or_more_feedback" now responds accordingly to the slicer "StoreID" selections. It works now.
Thanks to all for taking the time to analyze this problem and for replying!
@Anonymous May i know from which table you have created the slicer Table_CustList[StoreID] or Table_StoreList[StoreID] ?
@Anonymous The slicer StoreID was from Table_StoreList[StoreID]. It is working for the other card visuals in the same report page. Any idea?
@Anonymous Can you change the direction in the Relationship like Table_StoreList[StoreID]-> Table_CustList[StoreID]
or change it to 'Both Direction' and try !
I have tried modifying the direction in the relationship and it does not seem to work for me.
I have realized that the slicer does not affect any of the card visuals from Table_Cust_with_Feedback so I have deleted the Table_Cust_with_Feedback and created the following within Table_CustList:
Calculated columns
Table_CustList[Number_of_Feedback_Received] = CALCULATE(DISTINCTCOUNT('Table_Feedback_Received'[FeedbackID]), FILTER('Table_Feedback_Received', 'Table_Feedback_Received'[CustID] = 'Table_CustList'[CustID]))
Measure
Cust_with_3_or_more_feedback = CALCULATE(COUNT('Table_CustList'[CustID]), FILTER('Table_CustList', 'Table_CustList'[Number of Feedback_Received]>=3))
Card visual "Cust_with_3_or_more_feedback" now responds accordingly to the slicer "StoreID" selections. It works now.
Thanks to all for taking the time to analyze this problem and for replying!
@Anonymous ,
Generally, you may modify the measure using dax below:
Table_Cust_with_Feedback[Cust_with_3_or_more_feedback] = CALCULATE ( COUNTROWS ( 'Table_Cust_with_Feedback' ), FILTER ( 'Table_Cust_with_Feedback', 'Table_Cust_with_Feedback'[Number_of_Feedback_Received] >= 3 ), ALLSELECTED ( Table_StoreList ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jimmy!
Thanks for your reply!
I have tried the modification suggested but it did not work for me. Is there any other modification that I can try?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.