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
Not sure on how to tackle the following problem i am trying to use my dis connected table _Trend to filter the date in the two visulaisations as show in the pbix file (first table).
So if the user selects No Trend then only show data points in the table that say No Trend and the filtered values in the table below.
link: https://www.dropbox.com/s/kmmmguw9fidt2ct/Sample__v.1.16.pbix?dl=0
Solved! Go to Solution.
Hi @Anonymous
You want "PMSComplaintsMN" measure to show values of "No Trend" when selecting ""No Trend", right?
From your measure
Significance Y = IF( '_Measures'[p-value] <= 0.05, "Significant Trend", "No Trend" )
It seems "No Trend" means '_Measures'[p-value] > 0.05
If so, you could create "PMSComplaintsMN" measure as below:
PMSComplaintsMN = CALCULATE ( IF ( ISBLANK ( COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), BLANK (), COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), FILTER ( ALLSELECTED ( PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND] ), '_Measures'[p-value] > 0.05 ) ) + 0
(ps: if your file contains some important information or private information, please delete it from here, next time, if you need to share files, just share a simple example)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
You want "PMSComplaintsMN" measure to show values of "No Trend" when selecting ""No Trend", right?
From your measure
Significance Y = IF( '_Measures'[p-value] <= 0.05, "Significant Trend", "No Trend" )
It seems "No Trend" means '_Measures'[p-value] > 0.05
If so, you could create "PMSComplaintsMN" measure as below:
PMSComplaintsMN = CALCULATE ( IF ( ISBLANK ( COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), BLANK (), COUNTA ( 'PMS_COMPLAINT'[MATERIAL_ID] ) ), FILTER ( ALLSELECTED ( PMS_FINANCIAL_PDS[ROLL12_COMPLETE_PDS_IND] ), '_Measures'[p-value] > 0.05 ) ) + 0
(ps: if your file contains some important information or private information, please delete it from here, next time, if you need to share files, just share a simple example)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Maggie
having trouble filerting the below graph same criteria... posted new question
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |