DAX expressions returning different results (CALCULATE vs CALCULATETABLE)
Hello, I encountered confusing results when creating measures using DAX calculations. It appears I’m getting different outputs when using CALCULATE vs CALCULATETABLE in certain circumstances. I’m not getting the expected output when using CALCULATE. I’m adding filter context on both measures and the filter context is the same. Details below. Measures used: SAO Opportunities = CALCULATETABLE( ROW ("SAO Opportunities", COUNTROWS(Opportunity) ), KEEPFILTERS ( TREATAS ( {"true"}, 'Opportunity'[SAO] )), USERELATIONSHIP ( 'Date'[Date], Opportunity[SAO Date]) ) SAO Opportunities (Calculate function) = CALCULATE ( COUNTROWS ( Opportunity ), FILTER ( Opportunity, Opportunity[SAO] = "true" ), USERELATIONSHIP ( 'Date'[Date], Opportunity[SAO Date] ) ) Output: For further context, there is an inactive relationship set up for the Date table with the Opportunity SAO Date field. There is a column in the Opportunity table called SAO and it’s a text field. When I filter the data in the Data View section to meet the above criteria, here is the output (matches output from CALCULATETABLE): Is anyone able to provide insight into the discrepancy? Thanks!Setting Conditional Images in paginated reports
I am trying to set conditional images on a report based off a parameter selected in my report? So in essence a parameter determines which image is selected to appear in the report with each parameter switching images? I've found the tooltip and use this image, and thats where I think it'll happen? How do I have a parameter show up on my report with it just saying the text of the parameter selected?
