Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
@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
Hi Amit,
I am getting the following error message:
"The DISTINCTCOUNT function only accepts a column reference as an argument."
Thanks!
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.
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |