Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
108 | |
108 | |
93 | |
70 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |