Weekend Notes - Manage Sets

Manage Sets (MDX)

DrillDown-Slicer

{[DimCustomer].[CustomerGeo].[All],
IIF( [Measures].[Distinct Count of Country] > 1,
[DimCustomer].[CustomerGeo].[Country], [DimCustomer].[CustomerGeo].[City] ) }

DateSlicers1 via 'Manage Sets'

DateSlicers2 via 'Manage Sets'

----

---
CONCATENATEX( )

[Selected]:= CONCATENATEX( ALLSELECTED(Products[Subcategory]),
                           Products[Subcategory], ", " )

----
Login to Multiple Accounts




---
PowerBI-gateway explained


---

EXPORTING DATA FROM POWER BI DESKTOP: Part1, PART2

--

Use Slicers for Query Parameters

----