Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to create parameters in Power BI

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!

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

        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.