Forum Discussion
Using Parameters on PBI desktop with a Live Connection to SSAS Tabular
You can use dummy table in cube, means let's say you want to take input from number, based on your requirement you can create one dummy table having one column with number series like 1 to 100 or anything.
Create table in model and don't make any relationship with that table.
Now use that column in slicer and write measure.
Let's say in your fact you have one measure and you want to display measure only if it is greater than selectedValue.
So create measure at power BI level/Cube level, it works fine in both condition.
Measure=if(Sum(Fact[amount])> Selectedvalue(Dummy[Series]),1,0)
Add measure in visual level filter and set measure is 1.
For data inputs as well you can create one data dummy table in cube and used it as slicer.
Calculated table as
Date Table =CALENDAR (DATE(2000;1;1); DATE(2025;12;31))
refrest that calculated table once and check again. Becuase same thing is working in my case. Make sure this table is not connected with other tables.
in my case dummy calculated tables are not showing when i am processing model. why is it showing in your case?
Just now i have rechecked, first do "process all" and then deploy model to analysis services.
Yes sorry so just to clarify. When 'Processing All', its only processing real tables. When deploying to services, it deployed all tables including dummy tables. But for some reason, the dummy table is showing as 0 rows transferred in the deploying status box, and not showing any errors. I've just tried again and it's still showing the same error in SSMS also.
Is this because I'm running on 2016 RTM?