ssasssas-2008
How could I display the sum of quantity from the fact table FacturesAvoir for each requestNo from the table F_demande_Achat?
How could I display the sum of quantity from the fact table FacturesAvoir for each requestNo from the table F_demande_Achat?
Solution
You'll need to set up a dimension that includes the three "F_" tables, and then link that dimension to the Measure Group that uses FacturesAvoir as its source.
- Can't add members to SSAS role through Visual Studio
- Power BI calculate Measure for previous working day
- User doesn't have permission to call the Discover method
- SSIS Cube process fail
- Cannot find SQL Server Analysis Services in SQL Server 2012 Management Studio
- "string was not recognized as a valid datetime" when building schema with wizard
- Measure DAX formula with SWITCH
- Is it possible to use the value from a table column as the text of a DAX formula for measure?
- MS SSAS MDX Ensure UI (E.g. Excel) shows the latest member of a dimension on refresh
- Visual Studio tabular cube: an M partition uses a data function which results in access to a data source different from those defined in the model
- C# amo get roles complete
- MDX function to find if a Member IsMemberOf a set
- Exclude attribute value by default in SQL Server Analysis Services Tabular Model
- Power BI - Find the % matching What-if analysis before and after
- Connect an on-prem SQL Server Analysis Server Tabular Model with Azure Data Factory
- My SQL Server Analysis services won't switch from tabular to multidimensional
- Aggregating Members calculated with IIF / CurrentMember conditions
- How to calculate a YTD based on the Month short
- MDX for concatenated dimension level based on result of another calculated member in cube design
- SSAS Tabular Model - Partition Refresh and Schedule
- Refresh SSAS post ETL Process job
- Write MDX / DAX on azure analysis services and copy data to azure data warehous using ADF
- How to create Analysis Services Multidimensional Project template in Visual Studio 2019?
- SSAS/Power BI Row Level Security
- PowerShell script to refresh tabular cube on Azure
- DAX FILTER function with multiple criteria
- How to take MDX Query from SSAS Multidimensional Cube and Use To Build Power BI Report?
- How to join two cubes on a shared dimension using MDX?
- DAX - YoY Calculation don't work on higher Date level
- How to get around SQL Server Analysis Services 2 billion distinct value limitation on a column