Forum Discussion

matemusic's avatar
matemusic
Icon for Advocate III rankAdvocate III
9 years ago

Filter with measurement

Hi Everyone,    I hope you will be aple to help with the following challenge.   In data model I have a table with next columns: date, product, sales and goal. In table there are 5 products.   F...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I feel as if this *is* possible, but you are going to have to use a "disconnected slicer" (aka, "disconnected table") and some tricky DAX.  I would look through some P3 archives and see if you are inspired :)   http://www.powerpivotpro.com/tag/disconnected-slicers/

 

Like, a table that JUST has 2 rows "Failed" and "Succeeded".  Then measures like...

MySuperMeasure = IF ( [Current Success or Failure Table Value] = "Failed", [FailureMeasure], [SuccessMeasure])

 

Use MySuperMeasure AND the field from your 2 row rable in your visuals?

  • matemusic's avatar
    matemusic
    Icon for Advocate III rankAdvocate III
    9 years ago

    Hey, thanks for your help, but it didnt solve my problem. Anyway, with today new Power bi release, I can finally get excepted result .

    I used new Top N filter feature and one easy trick :)   

     

    I will try to create demo pbix file and share it.