Forum Discussion
Measure Help
Hi All, Can someone help me in correcting the below formula(received from Amith)? Where there is no relationship between the table. Measure = CALCULATE([TVPS], FILTER('S&P', 'S&P'[SubServi...
This clarifies your question a little bit, but I'm still not sure where the 14,471,559 value should be coming from? Something like this might get you closer: Measure = SUMX(
FILTER(ALL('S&P'),
'S&P'[SubServiceLineGroupingDesc]in VALUES('Comparision SSL'[SSL])),'S&P'[TotalValueOfPotentialSale])
But I don't know what this number is trying to show, so not sure what additional filters need to be placed on it.
FILTER(ALL('S&P'),
'S&P'[SubServiceLineGroupingDesc]in VALUES('Comparision SSL'[SSL])),'S&P'[TotalValueOfPotentialSale])
But I don't know what this number is trying to show, so not sure what additional filters need to be placed on it.
this started giving the total of Audit Value.
In the below SS hope you can make the difference.
Whenever I cross filter from both the slicer I should be getting the count and the value.
The value I am getting is the Total value of the Audit. can see the same value bit the count changes.