PowerPivot Forum

The purpose of the example is how to report based on 2 data (fact) tables. We need to have common lookup tables for both fact tables in order to create such a report. The BudgetPeriod (Lookup) table is connected to Budget table The BudgetPeriod table is connected to Calendar table which in turn is c...

It is not necessary to have a visual on the canvas to use What-if New Parameter. As Matt said, it might be some minor bug somewhere. Save and close the workbook. Reopen it - it might work.

Click on Modeling tab in the menu.
You can then select New Parameter

If you want to learn more about dealing with slowly changing dimensions, please consider the online training course Dimensional Modeling for the Power BI Pro by Matt Allington, Ken Puls and Miguel Escobar https://www.skillwave.training/courses/ ... er-bi-pro/

First check what version of Power BI Desktop you have.
Click on Help and then on About.
The latest version as of today is October 2020 version.
If you install Power BI Desktop from Microsoft Store, then it gets updated automatically

I think that you can clean your data before loading so that your DAX formulas will be simple as you will have only the necessary data. Go to Power Query. Filter CATEGORY column to have only ACCEPT values Select ID NUMBERS column and remove duplicates Load the table Total Amount = SUM(TABLE(SALES AMO...

Could you share your sample data?
The data that you have and the result you are expecting out of it.

Try this -
Count Unique Values = DISTINCTCOUNT('Table'[ID NUMBERS ])
Count Unique Accept Values = CALCULATE([Count Unique Values], 'Table'[CATEGORY] = "ACCEPT")

SWITCH function works for both measures and calculated columns. The above example is for a calculated column using SWITCH function. Here is an example of SWITCH function for a measure: ( Chapter 17 , Section Here’s How: Creating a Morphing Switch Measure Measure to Display = SWITCH([Selected Measure...

The formula is
House Ownership =
SWITCH(Customers[HouseOwnerFlag],
1,"Owns their house",
0,"Doesn't own their house",
"Unknown"
)
Please check that there are no typos in the formula.
Intellisense cannot point out typos