topic Re: I need a slicer to change all records in the table to 0 in DAX Commands and Tips

I need a slicer to change all records in the table to 0

Anonymous — Tue, 31 May 2022 14:14:53 GMT

Hello everyone,

Suppose I have a table and table has 7 measures, and each measures brings records, null or zero

It's being refreshed everyday.

What I need to do is to create a slicer and with one function :

when I say turn on activity It will show all the records

from the database as is (default)

When I say turn off activity It will show for the first 5 measures all 0 and rest of the 2 measures stay with records.

so, it's going to effect first 5 measures

any ideas ?

Re: I need a slicer to change all records in the table to 0

amitchandak — Wed, 01 Jun 2022 02:40:24 GMT

Anonymous , you can use isfiltered

if(isfiltered(Table[Column]), [Measure1], 0)

same way for other measures

if(isfiltered(Table[Column]), [Measure2], 0)

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

it can be based on the value

if(selectedvalue(Table[Column]) <> "Hide", [Measure2], 0)

Re: I need a slicer to change all records in the table to 0

Anonymous — Sun, 05 Jun 2022 19:51:35 GMT

Hi

Thank you for the response,

Correct I get a new column depending on [measure1] and all values are zero.
but,

I need a slicer (AAS model only allow me to create a measure not a calculated column)
to suppose we have a column with values

column: measure1
1st row : 16
2nd row: 18
3rd row: 7
4th row: 3
so on...
and

I want to see
all zeros on "that" column
0
0
...all

is there any way to do it ?

Re: I need a slicer to change all records in the table to 0

Anonymous — Thu, 09 Jun 2022 06:01:36 GMT

Hi Anonymous ,

I'm afraid I don't have a suitable way to implement your requirements. The data source you are connecting to is AAS and is in live connection mode, which can only create report level measure, not calculated tables, calculated columns, etc. Then there is no appropriate column to apply to the slicer since you can't create calculated columns or calculated tables...
If the connection mode of the report is Import, you can refer to amitchandak 's approach and modify the first 5 measures.

Measure1= IF(SELECTEDVALUE(Table[Column]) <> "Hide", SUM([colname]), 0)

Best Regards

Re: I need a slicer to change all records in the table to 0

Anonymous — Fri, 10 Jun 2022 22:30:41 GMT

Right,

I was thinking to change data science queries to add another column and process the table in the aas model then use it in the pbix file.

I don't know it's good or bad now ? because business doesn't need this slicer for now

so, it's been hold off

thank you for advice.