Forum Discussion

Anonymous

Not applicable

6 years ago

hasonefilter on table with measures. totals wrong

Hi, i have a matrix visual based on 2 tables(rows and columns). The values are calculated with a measure. The measure compares a value, if the value is ther it enters acalculated value if not the...

Anonymous

Not applicable

6 years ago

Hi,

i tried the approach and played with it around, But always im getting wrong totals.

It seems that the Filter of the Visual is ignored.

Regards

Icon for Community Support rank

Community Support

6 years ago

Hi Anonymous ,

Could you pls upload your .pbix file to onedrive business and share the link with us?

Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Anonymous
Not applicable
6 years ago
Hi,

the PBIX is to big and has many other things in it.

I also have another open topic zo solve this issue through a virtual table, but this is also not solved.

https://community.powerbi.com/t5/Desktop/Calculated-or-Virtual-table-based-on-3-tables/m-p/1441720#M605519

An example Data model can be simple like that:

The measure would be look like:

Travelcost = var daycost =if([count(case id)]>0,"1","0")
return
sumx(values('Calendar'[Date]),if(HASONEFILTER('Calendar'[Date]),daycost,sumx('Calendar',daycost)))

The purpose is also simple:
if i have more than one case per day put in a fixed cost for that day. This works fine, but not the totals

I will generate a simple PBIX 🙂 but need to find some free time to do that.

Thanks
- Anonymous
  Not applicable
  6 years ago
  Hi,
  
  i have created an example PBIX.
  
  How can i upload it?
  
  (The file type (.pbix) is not supported.)
  
  Regards
  - v-kelly-msft
    Community Support
    6 years ago
    Hi Anonymous ,
    
    Pls upload your sample .pbix file to onedrive business and share the link with us.
    
    Best Regards,
    Kelly
    
    Did I answer your question? Mark my post as a solution!

Related content