How to create parameters in Power BI

[Anonymous]

Hi,

Can you please help me create the following paramter in Power BI?

Left or Remained(Parameter)

Value                  Display As

1                         Left

2                         Remained

Compute By (Parameter)

Attribute

Total Population

And then converting the following calculated fields in Tableau to DAX:

Compute Filter

CASE [Compute By]

WHEN '1' THEN [% Across]

WHEN '2' THEN [% Down]

END

N

IF [Compute By] = '1' THEN COUNTD([Student Id]) ELSE NULL END

N ALANA

{ FIXED [ALANA] :COUNTD(IF [Resident - Show/Hide] THEN [Student Id] END)} + { FIXED [ALANA] :COUNTD(IF [Resident - Show/Hide] = FALSE THEN [Student Id] END)}

Thanks!

[amitchandak]

@Anonymous , You can do the first one you can use switch like

Switch(selectedvalues([Compute By]) ,
"1" , [% Across] ,
"2" , [% Down]
)

if (Max([Compute By]) = "1" , COUNTD([Student Id]) , blank())

or

if (selectedvalu([Compute By]) = "1" , COUNTD([Student Id]) , blank())

for fixed refer my video

LOD- FIXED (Level of Details): https://youtu.be/hU-cVOwDCvY

you need use allexcept using the fact/central table

[Anonymous]

Hi Amit,

I am getting the following error message:

"The DISTINCTCOUNT function only accepts a column reference as an argument."

N ALANA = CALCULATE( DISTINCTCOUNT( IF (Sheet1[Resident - Show/Hide], Sheet1[Student Id], ALLEXCEPT(Sheet1, Sheet1[ALANA]) ) ) )

&

CALCULATE( DISTINCTCOUNT( IF(Sheet1[Resident - Show/Hide] = "FALSE", Sheet1[Student Id]), ALLEXCEPT(Sheet1, Sheet1[ALANA]) ) )

Thanks!

[Anonymous]

Hi  @Anonymous , 

The DISTINCTCOUNT function counts the number of distinct values in a column. There should be a column name in the function. You should create a formula like

N ALANA = CALCULATE(DISTINCTCOUNT( <column>, FILTER(<table>,<filter>))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.