Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |