Forum Discussion

Nivas538's avatar
Nivas538
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Measure should Calculated based on the Slicer selected

Hi,

 

I have a below requirement 

 
1. Count is calculated from below measure 
Total Count = CALCULATE(COUNT(Registration[Name]))
 Total Count  Card Visual
 
 
 Slicers
Requirement is 
 When i select Attended as "NO"  and if i select or unselect the Date filter total count should not change and if i select Attended as No for anyother slicer eg.if is select Vertical it should change as per the selection.
So, only for Date filter Attended as "NO" shouldnot change the total count
 

Thanks In Advance,

Sri.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    try this

     

    Total Count = CALCULATE(COUNT(Registration[Name]),all(Registration[Date]))

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Better, you more date to date table and try option2

    //Option 1
Total Count = 
var _max =maxx(allselected(Table(,Table[Attended])
var _1 = if(_max = "NO",
				CALCULATE(COUNT(Registration[Name])),CALCULATE(COUNT(Registration[Name]),all(Registration)))
return
_1
//Option 2
Total Count = 
var _max =maxx(allselected(Table(,Table[Attended])
var _1 = if(_max = "NO",
				CALCULATE(COUNT(Registration[Name])),CALCULATE(COUNT(Registration[Name]),all(DATE)))
return
_1
  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Nivas538 ,

     

    Is your issue solved?

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!