Fact Cashback

Description
Data Category
Modified Time
2022-05-20 00:00:00

Name Type Description Properties
Cashback Amount 1
Cashback CAD Amount 1
Cashback Conversion Date Key 1
Cashback COP Amount 1
Cashback CRC Amount 1
Cashback Detail Key 1
Cashback EUR Amount 1
Cashback GBP Amount 1
Cashback GTQ Amount 1
Cashback HNL Amount 1
Cashback INR Amount 1
Cashback JPY Amount 1
Cashback MXN Amount 1
Cashback NIO Amount 1
Cashback PHP Amount 1
Cashback Rates Key 1
Cashback SGD Amount 1
Cashback Transaction Date Key 1
Cashback USD Amount 1
RowNumber-2662979B-1795-4F74-8F37-6A1BA8059B61 3 Primary Key Unique
User Key 1

Name Expression Description
Count of Cashback Amount COUNTA([Cashback Amount])
Count of Cashback Approved CALCULATE( Count('Fact Cashback'[Cashback Amount]), ('Cashback Detail'[Cashback Detail Status] = "Approved" || 'Cashback Detail'[Cashback Detail Status] = "approved"), 'Cashback Detail'[Cashback Detail Is Redemption] <> "Redemption" )
Count of Cashback Available CALCULATE( COUNT('Fact Cashback'[Cashback Amount]), Filter('Cashback Detail',('Cashback Detail'[Cashback Detail Status] = "Approved" || 'Cashback Detail'[Cashback Detail Status] = "approved" || 'Cashback Detail'[Cashback Detail Is Redemption] = "Redemption" )) )
Count of Cashback Distinct User CALCULATE( DISTINCTCOUNT(User[User Id]), FILTER('Fact Cashback','Fact Cashback'[Count of Cashback Available]) )
Count of Cashback Id Count('Fact Cashback'[Cashback Amount])
Count of Cashback Pending CALCULATE( Count('Fact Cashback'[Cashback Detail Key]), ('Cashback Detail'[Cashback Detail Status] = "Pending" || 'Cashback Detail'[Cashback Detail Status] = "pending"), 'Cashback Detail'[Cashback Detail Is Redemption] <> "Redemption" )
Count of Cashback Redeemed CALCULATE( COUNT('Fact Cashback'[Cashback Amount]), 'Cashback Detail'[Cashback Detail Is Redemption] = "Redemption" )
Count of Cashback Redemption Distinct Users CALCULATE( [Count of Cashback Distinct User],'Cashback Detail'[Cashback Detail Is Redemption] = "Redemption")
Sum of Cashback Amount SUM([Cashback Amount])
Sum of Cashback Approved CALCULATE( SUMX('Fact Cashback','Fact Cashback'[Cashback Amount]), ('Cashback Detail'[Cashback Detail Status] = "Approved" || 'Cashback Detail'[Cashback Detail Status] = "approved"), 'Cashback Detail'[Cashback Detail Is Redemption] <> "Redemption" )
Sum of Cashback Available CALCULATE( SUM('Fact Cashback'[Cashback Amount]), Filter('Cashback Detail',('Cashback Detail'[Cashback Detail Status] = "Approved" || 'Cashback Detail'[Cashback Detail Status] = "approved" || 'Cashback Detail'[Cashback Detail Is Redemption] = "Redemption" )) )
Sum of Cashback Pending CALCULATE( SUM('Fact Cashback'[Cashback Amount]), ('Cashback Detail'[Cashback Detail Status] = "Pending" || 'Cashback Detail'[Cashback Detail Status] = "pending"), 'Cashback Detail'[Cashback Detail Is Redemption] <> "Redemption" )
Sum of Cashback Redeemed CALCULATE( SUMX('Fact Cashback',abs('Fact Cashback'[Cashback Amount])), 'Cashback Detail'[Cashback Detail Is Redemption] = "Redemption" )