HansPeterPfister

let
Quelle = Table.AddColumn(Trans, "Merge",
        (case_insensitive) => Table.SelectRows(Dept,
        each Text.Upper([Name]) = Text.Upper(case_insensitive[Name]))),
#"Expanded Merge" = Table.ExpandTableColumn(Quelle, "Merge", {"Name", "Dept"}, {"Emp.Name", "Emp.Dept"})
in
#"Expanded Merge"

HansPeterPfister

Sales Profit = If (
                [RLS_Measure]=0; 
                  BLANK();
                 SUM(FactResellerSales[SalesProfit]) * [RLS_Measure]
               )

HansPeterPfister

Profit pct = If (
                [RLS_Measure]=0; 
                  BLANK();
                  DIVIDE([Sales Profit]*100;[Sales Amount]) 
                  * [RLS_Measure]
               )

HansPeterPfister

Product Cost = if( 
                    [RLS_Measure]=0 ; 
                      BLANK(); 
                      sum(FactResellerSales[TotalProductCost]) * [RLS_Measure]
                  )

HansPeterPfister

RLS_Measure = LOOKUPVALUE(
                RLS[ShowMeasures];
                RLS[User];USERNAME()
              )

HansPeterPfister

if(
  maxx(
      Filter(RLS,
            RLS[User]=USERNAME()
        )
  ,[Role]) = "Board" ||
  maxx(
      Filter(RLS,
            RLS[User]=USERNAME()
         )

HansPeterPfister

if(
   maxx(
	Filter(RLS,
		RLS[User]=USERNAME()
	)
     ,[Role]) = "Board" ||  
    maxx(
	Filter(RLS,
		RLS[User]=USERNAME()
	)

HansPeterPfister

Umsatz = CALCULATE(
          SUM(Umsatzliste[Wert])
          )

HansPeterPfister

Umsatz Plan =
CALCULATE(
        sum(Umsatzliste[Wert]);
        Filter(Umsatzliste;Umsatzliste[Szenario]="Plan");
        Filter(Kalender;Kalender[relatives Jahr]>0)
        )

HansPeterPfister

Umsatz Plan aktuelles Jahr =
CALCULATE(
      sum(Umsatzliste[Wert]);
      Kalender[relatives Jahr]=0
      )