Forum Discussion

Fahad12's avatar
Fahad12
Frequent Visitor
3 years ago

How to Make Column = Unfiltered Data

So my issue is as follows:  I have a set of data as follows:    Department Name productivity % A 10% B 30% C 5% D 15% E 60%         I wanted to construct a DAX fun...
Need Help
Tips and Tricks
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

 

 

Expected result measure: =
VAR _slicerselectcount =
    COUNTROWS ( ALLSELECTED ( Data[Department Name] ) )
VAR _alldeptcount =
    COUNTROWS ( ALL ( Data[Department Name] ) )
RETURN
    IF ( _slicerselectcount = _alldeptcount, 0.2, SUM ( Data[productivity %] ) )

 

Fahad12's avatar
Fahad12
Frequent Visitor
3 years ago

Yeah there is one note here...  the graph I am trying to plot is from another dataset that is not in this table.... this table is only an applied filter on top of that dataset graph.... the filter is the department name so when you choose it it displays the productivity% on top of that graph... so I was struggling with how I can include it in the IF statement that if select all departments then productivity% = 20%