Forum Discussion

MiKeZZa's avatar
MiKeZZa
Icon for Post Patron rankPost Patron
9 years ago
Solved

Calculate value based on slicer

I'm looking for a solution for this case:   A user must be able to see anything from any other department, but when the reported opens by default it must only show his own department(s).   It see...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago
    MiKeZZa wrote:

    Yes, I want exactly what you describe but then without placing a filter in the visual....

     

    So I want every new added visual directly to lack the data that is filtered out in the visual with CustCount > 0 to prevent making mistakes by using the original measure's (I won't hide them)

    Hi MiKeZZa,

    The method I can think out is to drag the CustCount to "Report level Filters" and set the value of it to be greater than 0.  

    Thanks,
    Lydia Zhang

MiKeZZa's avatar
MiKeZZa
Icon for Post Patron rankPost Patron
9 years ago

I've now made these Measures:

  1. CustCountFiltered
    CustCountFiltered = CALCULATE(DISTINCTCOUNT(Table_ProductionNumber[CustomerID]), FILTER(TableProductionNumber, TableProductionNumber[User_Email]="[email protected]"))
  2. CustCountNotFiltered: 
    DistinctCount(Table_productionNumber[CustomerID])
  3. CustCount
  1. if(max(ShowOnlyDepartment_Slicer[OnlyOwnDepartment])="Yes",[CustCountFiltered],[CustCountNotFiltered])

     

This works well for now! The onliest thing is that I have to make something for the hardcoded mailadress. In PowerBI Desktop USERPRINCIPALNAME() doesn't work; the filtered values are empty then. But I'll give it a try after publishing.

 

This all works fine. So I'm happy now. But the onliest thing I'm interested now is if there is a possiblity to automatically filter the whole dataset. This because of that I now have to filter a table with CustCount > 0.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi MiKeZZa,

Could you please describe more details about automatically filtering the whole dataset? We will appreciate that if you can share sample data of your tables and post expected result here.

If you want to filter data with “CustCount>0”, just drag the measure to the visual level filter of your table visual and set the value of the measure to be greater than 0.


Thanks,
Lydia Zhang

  • MiKeZZa's avatar
    MiKeZZa
    Icon for Post Patron rankPost Patron
    9 years ago

    Yes, I want exactly what you describe but then without placing a filter in the visual....

     

    So I want every new added visual directly to lack the data that is filtered out in the visual with CustCount > 0 to prevent making mistakes by using the original measure's (I won't hide them)

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago
      MiKeZZa wrote:

      Yes, I want exactly what you describe but then without placing a filter in the visual....

       

      So I want every new added visual directly to lack the data that is filtered out in the visual with CustCount > 0 to prevent making mistakes by using the original measure's (I won't hide them)

      Hi MiKeZZa,

      The method I can think out is to drag the CustCount to "Report level Filters" and set the value of it to be greater than 0.  

      Thanks,
      Lydia Zhang