Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Tableau Function in Power BI

I've recently been tasked with moving some of my Tableau Dashboards over to Power BI and like a lot of the users on here, I'm struggling getting some stuff involving LOD's to function in DAX. It's pr...
  • Jimmy801's avatar
    Jimmy801
    6 years ago

    Hello Anonymous 

     

    this measure won't work as a filter as it returns always a distinct count meaning a scalar value. And single scalar value can't not filtered. So you have to apply this formula as a new column in your data table and then using this new column as filter.

    Hope this helps

     

    Jimmy

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you for the detailed response. I'm going to give this a try this evening and see if it produces the desired affect.

 

-Micah

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

No Problem, just don't forget to mark it as a solution if it does fit your needs (more than 1 response can be your solution) for others with similar questions to find the answer quickly.

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂