Forum Discussion
Dunner2020
Post Prodigy
Post ProdigyCard and table visual display different result for same measure
Hi there,
I have created a measure which calculates the count of event occurred. When I tried to display it on the card, it shows a blank. However, when I tried to display on the table visual it shows three rows of the data as shown in the figure:
I am not sure where I made the mistake. I have attached the sample file here. Any help would be really appreciated.
Dunner2020 You were close, just need to give the card measure the same row context as the table. In this measure it uses the row context of the raw data table, is that correct?
Late retailer notification =SUMX(FILTER('Outages and Interruptions','Outages and Interruptions'[InterruptionType]="2" && YEAR('Outages and Interruptions'[Retail Consumer Retailer Notify (NZST)]) >1900 && DATEDIFF('Outages and Interruptions'[Retail Consumer Retailer Notify (NZST)], 'Outages and Interruptions'[Actual Interruption Start Time (NZST)], DAY) < 10 && YEAR('Outages and Interruptions'[Cancelled Date (NZST)]) =1900),1)
1 Reply
- AllisonKennedy
Community Champion
Dunner2020 You were close, just need to give the card measure the same row context as the table. In this measure it uses the row context of the raw data table, is that correct?
Late retailer notification =SUMX(FILTER('Outages and Interruptions','Outages and Interruptions'[InterruptionType]="2" && YEAR('Outages and Interruptions'[Retail Consumer Retailer Notify (NZST)]) >1900 && DATEDIFF('Outages and Interruptions'[Retail Consumer Retailer Notify (NZST)], 'Outages and Interruptions'[Actual Interruption Start Time (NZST)], DAY) < 10 && YEAR('Outages and Interruptions'[Cancelled Date (NZST)]) =1900),1)