single column

2 Topics

Dynamic Slicer based on another Slicer (return filtered text column)
Hi DAXperts, My model has a 12 months (text) slicer - this slicer should be dynamic based on an option selected on another ("Data Set") slicer. The 12 months are to be used as column titles for a data table. This 12 months would show the first X historical months and the remaining Y "budget" or "forecast" months. However, my model is currently showing both Budget & Forecast months. I need it to show Budget or Forecast months only based on the ("Data Set") slicer value selected. Please see below image and attached PBIX file. Any suggestions and work arounds much appreciated.
Solved
Khang
4 years ago Place DAX Commands and Tips
1.2KViews
0likes
3Comments
Percentage Calc Based on Three Values (Pass, Fail, Not Inspected)
Afternoon, I'm looking to put a Pass Rate Calc in my file that will allow for three values in a single column - Pass, Fail and Not Inspected. For example, lets say I have a sample of 150 cars; 50 of those cars passed inspection, 50 of those cars failed inspection and the remaining 50 were not inspected. As such, my pass rate on this is 50%. I have the below DAX, which I assume should work; Calc Inspection Result Pass Rate = DIVIDE( CALCULATE( COUNTROWS('EXTRACT') , 'EXTRACT'[Overall Result - Post Appeal] = "Pass" , COUNTROWS('EXTRACT') , 'EXTRACT'[Overall Result - Post Appeal] = "Fail") , CALCULATE( COUNTROWS('EXTRACT') , 'EXTRACT'[Overall Result - Post Appeal] = "Pass") , BLANK() ) But I keep getting the below error message - The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column. Any ideas?
Solved
dcadwallader
4 years ago Place DAX Commands and Tips
1.2KViews
0likes
2Comments