Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts
See attached PBIX file. I am have trouble showing the filter results when selecting either No Trend and or Significant Trend in the Card Visual to the right of the table.
So if a user select No Trend i would expect to see the result 912 to be shown in the card visual and so on when selecting the Significant Trend button.
https://www.dropbox.com/s/g9mplolmeu9jlhj/Sample__Test.pbix?dl=0
Solved! Go to Solution.
Hi @Anonymous,
When you filter the trend in card, you change the right card to show no Trend/ Significant Trend, the two measure depends on the measure “P-value”, but the issue is that the p-value looks meaningful for the product in your shared table, we can try to modify your measures to following to meet your requirement.
No Trend = CALCULATE ( IF ( ISBLANK ( COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), BLANK (), COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), FILTER ( ALLSELECTED ( PMS_PARTS[Product] ), CALCULATE('_Measures'[p-value]) > 0.05 ) ) + 0
Significant Trend = CALCULATE( IF ( ISBLANK ( COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), BLANK (), COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), FILTER ( ALLSELECTED ( PMS_PARTS[Product] ), CALCULATE('_Measures'[p-value]) <= 0.05 ) ) + 0
Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more
Hi @Anonymous,
When you filter the trend in card, you change the right card to show no Trend/ Significant Trend, the two measure depends on the measure “P-value”, but the issue is that the p-value looks meaningful for the product in your shared table, we can try to modify your measures to following to meet your requirement.
No Trend = CALCULATE ( IF ( ISBLANK ( COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), BLANK (), COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), FILTER ( ALLSELECTED ( PMS_PARTS[Product] ), CALCULATE('_Measures'[p-value]) > 0.05 ) ) + 0
Significant Trend = CALCULATE( IF ( ISBLANK ( COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), BLANK (), COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), FILTER ( ALLSELECTED ( PMS_PARTS[Product] ), CALCULATE('_Measures'[p-value]) <= 0.05 ) ) + 0
Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more
Sorry for asking can you shed some light on
since you solved the other question in lighthing speed. I have used your method for the rest of my dashboard and it works fine, just stuck on one last part.
Community Support Team _ DongLi, thank you thank you, long live and god bless.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |